Skip to main content

ZTEST

Definition

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:

 

A
B
C
1
Data
The value to test (x)
2
3
4
3
6
4
7
5
8
6
6
7
5
8
4
9
2
10
1
11
9
12
13
One-tailed probability-value of a z-test for the data set above, at the hypothesized population mean of 4:
0.090574197
14
15
Two-tailed probability-value of a z-test for the data set above, at the hypothesized population mean of 4:
0.181148394

JavaScript errors detected

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

If this problem persists, please contact our support.

Contact Support Close