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

Syntax:

Z.TEST(Area, x [, Sigma])

Description:

This 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 a cell reference to the area against which x is to be tested. 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, PlanMaker automatically uses the standard deviation of the given sample (i.e., the values in Area).

Compatibility notes:

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

See also:

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