Excel functions / Statistics

NORM.DIST function

The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.

Syntax

=NORM.DIST(x, mean, standard_dev, cumulative)

Arguments

When to use it

NORM.DIST works with the normal (bell curve) distribution. With TRUE it gives the chance of a value at or below x; with FALSE the height of the curve at x. Give it the mean and standard deviation.

Examples

  1. Share of people under 180 cm, if heights average 170 with SD 8

    ABCDE
    1HeightMeanSD
    2180170889.4%

    In E2: =NORM.DIST(A2, B2, C2, TRUE) → 89.4%

    Try this example

  2. Share between 160 and 180

    ABCD
    1MeanSD
    2170878.9%

    In D2: =NORM.DIST(180, A2, B2, TRUE)-NORM.DIST(160, A2, B2, TRUE) → 78.9%

    Try this example

Common mistakes

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

Also written as NORMDIST.

Try NORM.DIST in the playground

Related functions