Filter
Top Products
358 Functions and commands
– ct
– cX1
– cX2
– stD
ConfZ1mean The ConfZ1mean calculates the confidence interval for a one-
sample Z-test.
ConfZ1mean(input list, ["configuration"])
ConfZ1mean(SampMean, SampSize, PopStdDevm
ConfLevel, ["configuration"])
• Input List: A list of input variables (see Input Parameters
below). This can be a range reference, a list of cell
references, or a simple list of values.
• Input Parameters:
– SampMean
– SampSize
– PopStdDevm
– ConfLevel
• Configuration: A string that controls what results are
shown and the order in which they appear. An empty
string "" displays the default: all results (including
headers).
– h = header cells will be created
– Z
– zXl
– zXh
– std
ConfZ2mean The ConfZ2mean calculates the confidence interval for a two-
sample Z-test.
ConfZ2mean(input list, ["configuration"])
ConfZ2mean(SampMean1, SampMean2,
SampSize1, SampSize2,
PopStdDev1,PopStdDev2 ConfLevel,
["configuration"])