ZTEST Function

The ZTEST function is one of the statistical functions. It is used to return the one-tailed probability-value of a z-test. For a given hypothesized population mean, μ0, ZTEST 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

ZTEST(array, x, [sigma])

The ZTEST 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 ZTEST function.

Examples

The figure below displays the result returned by the ZTEST function.