Returns the two-tailed P-value of a Z-test with standard distribution.

Sample Usage

ZTEST(A2:A100,B2)

ZTEST({1,2,3,4,5,6},5.5,1.2)

Syntax

ZTEST(data, value, [standard_deviation])

data - The array or range containing the dataset to consider.

value - The test statistic to use in the Z-test.

standard_deviation - [ OPTIONAL ] - The standard deviation to assume for the Z-test. If this is not provided, STDEV(data) will be calculated.

Notes

The P-value returned by ZTEST is the probability that a value chosen at random from data is at least as extreme (that is, as far from the mean) as value.

See Also

NORMSDIST: Returns the value of the standard normal cumulative distribution function for a specified value.

NORMDIST: Returns the value of the normal distribution function (or normal cumulative distribution function) for a specified value, mean, and standard deviation.

CONFIDENCE: Calculates the width of half the confidence interval for a normal distribution.

In order to use the ZTEST formula, start with your edited Excellentable:

Then type in the ZTEST formula in the area you would like to display the outcome:

By adding the values you would like to calculate the ZTEST formula for, Excellentable will generate the outcome:

Error.

User does not have sufficient privileges to access this Content Learn More

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.