Excel functions / Statistics

NORM.INV function

The value below which a given share of a normal distribution falls.

Syntax

=NORM.INV(probability, mean, standard_dev)

Arguments

When to use it

NORM.INV goes the other way from NORM.DIST: given a probability, a mean and a standard deviation, it gives the value below which that share falls. It answers "how tall is the tallest 5%?" or sets a safety stock for a service level.

Examples

  1. The height that 95% are under

    ABCD
    1MeanSD
    21708183.2

    In D2: =NORM.INV(0.95, A2, B2) → 183.2

    Try this example

  2. Stock for a 98% chance of not running out

    ABCD
    1Mean demandSD
    220030262

    In D2: =ROUNDUP(NORM.INV(0.98, A2, B2), 0) → 262

    Try this example

Common mistakes

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

Try NORM.INV in the playground

Related functions