Filter
Top Products
356 Functions and commands
HypZ1mean The one-sample Z-test for a mean.
HypZ1mean( ,n,
0
,,,mode, [”configuration”])
The input parameters can be a range reference, a list of cell
references, or a simple list of values.
Mode: Specifies which alternative hypothesis to use:
• 1: <
0
• 2: >
0
• 3: ≠
0
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. The options
in the configuration string are separated by spaces.
• h: header cells will be created
• acc: the test result, 0 or 1 to reject or fail to reject the null
hypothesis
• tZ: the test Z-value
• tM: the input value
• prob: the lower-tail probability
• cZ: the critical Z-value associated with the input α-level
• cx1: the lower critical value of the mean associated with
the critical Z-value
• cx2: the upper critical value of the mean associated with
the critical Z-value
• std: the standard deviation
Example:
HypZ1mean(0.461368, 50, 0.5, 0.2887, 0.05, 1,
"")
HYPZ2mean The two-sample Z-test for the difference of two means.
HypZ2mean( , ,n
1
,n
2
,
1
,
2
,,mode,
[”configuration”])
x
x
x
1
x
2