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
probability: The share, between 0 and 1.mean: The average of the distribution.standard_dev: Its standard deviation.
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
The height that 95% are under
A B C D 1 Mean SD 2 170 8 183.2 In D2:
=NORM.INV(0.95, A2, B2)→ 183.2Stock for a 98% chance of not running out
A B C D 1 Mean demand SD 2 200 30 262 In D2:
=ROUNDUP(NORM.INV(0.98, A2, B2), 0)→ 262
Common mistakes
- A probability outside 0 to 1. The probability must be between 0 and 1, not a percentage over 100.
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.
- Czech: NORM.INV
- Danish: NORM.INV
- Dutch: NORM.INV.N
- Finnish: NORMAALI.JAKAUMA.KÄÄNT
- French: LOI.NORMALE.INVERSE.N
- German: NORM.INV
- Hungarian: NORM.INVERZ
- Italian: INV.NORM.N
- Norwegian: NORM.INV
- Polish: ROZKŁ.NORMALNY.ODWR
- Portuguese (Brazil): INV.NORM.N
- Portuguese (Portugal): INV.NORMAL
- Russian: НОРМ.ОБР
- Spanish: INV.NORM
- Swedish: NORM.INV
- Turkish: NORM.TERS
Also written as NORMINV.
Try NORM.INV in the playground
Related functions
- NORM.DIST: The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
- NORM.S.INV: The z-score below which a given share of the standard normal distribution falls.
- PERCENTILE: The value below which a given percentage of the data falls.
- CONFIDENCE.NORM: The margin of error for an average: add and subtract it to get the confidence interval.