Manual

356 Functions and commands

HypZ1mean The one-sample Z-test for a mean.

HypZ1mean( , n,

,,,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:  < 

• 2:  > 

• 3:  ≠ 

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

,

,,mode,

[”configuration”])