<< Click to Display Table of Contents >> Z.TEST (z-test)

Syntax:

Z.TEST(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.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

See also:

ZTEST, STANDARDIZE, NORM.DIST/NORMDIST, NORM.S.DIST/NORMSDIST