ZTEST (z-test)

<< 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:

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).

See also:

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