Excel functions / Statistics

NORM.S.INV function

The z-score below which a given share of the standard normal distribution falls.

Syntax

=NORM.S.INV(probability)

Arguments

When to use it

NORM.S.INV gives the z-score below which a given share of the standard normal distribution falls. It supplies the critical values of statistics: 1.96 for a two-sided 95% interval.

Examples

  1. The z for a 95% two-sided interval

    ABC
    1Confidence
    295%1.96

    In C2: =NORM.S.INV(1-(1-A2)/2) → 1.96

    Try this example

  2. The z for the bottom 10%

    ABC
    1Share
    210%-1.28

    In C2: =NORM.S.INV(A2) → -1.28

    Try this example

Common mistakes

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

Try NORM.S.INV in the playground

Related functions