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
probability: The share, between 0 and 1.
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
The z for a 95% two-sided interval
A B C 1 Confidence 2 95% 1.96 In C2:
=NORM.S.INV(1-(1-A2)/2)→ 1.96The z for the bottom 10%
A B C 1 Share 2 10% -1.28 In C2:
=NORM.S.INV(A2)→ -1.28
Common mistakes
- One side or two. For a two-sided interval, split what is left over between the two tails: 95% leaves 2.5% on each side.
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.
- Czech: NORM.S.INV
- Danish: STANDARD.NORM.INV
- Dutch: NORM.S.INV
- Finnish: NORM_JAKAUMA.KÄÄNT
- French: LOI.NORMALE.STANDARD.INVERSE.N
- German: NORM.S.INV
- Hungarian: NORM.S.INVERZ
- Italian: INV.NORM.S
- Norwegian: NORM.S.INV
- Polish: ROZKŁ.NORMALNY.S.ODWR
- Portuguese (Brazil): INV.NORMP.N
- Portuguese (Portugal): INV.S.NORM
- Russian: НОРМ.СТ.ОБР
- Spanish: INV.NORM.ESTAND
- Swedish: NORM.S.INV
- Turkish: NORM.S.TERS
Also written as NORMSINV.
Try NORM.S.INV in the playground
Related functions
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- NORM.INV: The value below which a given share of a normal distribution falls.
- CONFIDENCE.NORM: The margin of error for an average: add and subtract it to get the confidence interval.
- T.INV.2T: The t-value with a given share of the distribution beyond it, counting both tails. This is the critical value of a two-sided test.