Z.TEST Function

The Z.TEST function is one of the statistical functions. It is used to return the one-tailed P-value of a z-test. For a given hypothesized population mean, x, Z.TEST returns the probability that the sample mean would be greater than the average of observations in the data set (array) — that is, the observed sample mean.

Syntax

Z.TEST(array, x, [sigma])

The Z.TEST function has the following arguments:

Argument	Description
array	The range of numeric values against which to test x.
x	The value to test.
sigma	A population standard deviation. This is an optional argument. If it is omitted, the sample standard deviation is used.

Notes

How to apply the Z.TEST function.

Examples

The figure below displays the result returned by the Z.TEST function.