<< Click to Display Table of Contents >> ZTEST (z-test)

Note: ZTEST is supplemented by the new identical function Z.TEST, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

ZTEST(Area, x [, Sigma])

Description:

Returns the one-tailed probability of a z-test.

You can use this function to check the probability that a sample comes from a certain population.

Area is the cell range or array containing the values x will be tested against. There should be at least 30 values.

x is the value to be tested.

Sigma (optional) is the standard deviation of the population (if known). If omitted, the standard deviation of the given sample (i.e., the values in Area) is used.

See also:

Z.TEST, STANDARDIZE, NORM.DIST/NORMDIST, NORM.S.DIST/NORMSDIST