Excel functions / Statistics
Z.TEST function
The one-tailed z-test: the chance of a sample mean this far above a claimed population mean.
Syntax
=Z.TEST(array, x, [sigma])
Arguments
array: The sample.x: The population mean being tested.sigma(optional): The known standard deviation of the population. Left out, the sample’s own is used.
When to use it
Z.TEST gives the one-tailed p-value of a z-test: the chance of a sample mean this far above a claimed population mean. Give the population standard deviation if it is known.
Examples
Is the mean above 4?
A B C 1 Value 2 3 0.0906 3 6 4 7 5 8 6 6 7 5 8 4 9 2 10 1 11 9 In C2:
=Z.TEST(A2:A11, 4)→ 0.0906
Common mistakes
- One tail. For a two-sided test, double the smaller of the result and 1 minus it.
Z.TEST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: Z.TEST
- Danish: Z.TEST
- Dutch: Z.TEST
- Finnish: Z.TESTI
- French: Z.TEST
- German: G.TEST
- Hungarian: Z.PRÓB
- Italian: TESTZ
- Norwegian: Z.TEST
- Polish: Z.TEST
- Portuguese (Brazil): TESTE.Z
- Portuguese (Portugal): TESTE.Z
- Russian: Z.ТЕСТ
- Spanish: PRUEBA.Z.N
- Swedish: Z.TEST
- Turkish: Z.TEST
Also written as ZTEST.
Related functions
- T.TEST: Student's t-test: the chance that two samples would differ this much if they came from populations with the same mean.
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- STANDARDIZE: A z-score: how many standard deviations a value is above (or below) the mean.