Excel functions / Statistics

NORM.S.DIST function

The standard normal distribution (mean 0, standard deviation 1) at a z-score.

Syntax

=NORM.S.DIST(z, cumulative)

Arguments

When to use it

NORM.S.DIST is the normal distribution with a mean of 0 and a standard deviation of 1. Give it a z-score and TRUE to get the share of values below it.

Examples

  1. Below a z-score of 1.96

    ABC
    1z
    21.9697.5%

    In C2: =NORM.S.DIST(A2, TRUE) → 97.5%

    Try this example

  2. Within one standard deviation of the mean

    ABC
    1z
    2168.3%

    In C2: =NORM.S.DIST(A2, TRUE)-NORM.S.DIST(-A2, TRUE) → 68.3%

    Try this example

Common mistakes

NORM.S.DIST 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

Try NORM.S.DIST in the playground

Related functions