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

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

  1. Is the mean above 4?

    ABC
    1Value
    230.0906
    36
    47
    58
    66
    75
    84
    92
    101
    119

    In C2: =Z.TEST(A2:A11, 4) → 0.0906

    Try this example

Common mistakes

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.

Translate a whole formula

Also written as ZTEST.

Try Z.TEST in the playground

Related functions