NORM.INV Function

Returns the value at a given probability of a normal distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice NORM.INV in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

NORM.INV works backwards from NORM.DIST: give it a probability and it returns the value that has that share of the distribution below it.

It answers questions such as "what call length covers 95% of calls?" — useful for service targets, safety stock and simulations (=NORM.INV(RAND(),mean,sd) draws a random bell-curve value).

Syntax

=NORM.INV(probability, mean, standard_dev) Explain

Arguments

ArgumentRequired?What it does
probabilityYesThe share below the value, between 0 and 1 (not including 0 or 1).
meanYesThe average of the distribution.
standard_devYesThe standard deviation; must be greater than 0.

Examples

Example 1 — A service target that covers 95% of calls

Northstar's support calls average 6 minutes with a standard deviation of 1.5 minutes.

B5fx=NORM.INV(B4,B2,B3)
AB
1MeasureValue
2Average (min)6
3Std deviation1.5
4Share covered0.95
5Call length8.47
6Shortest 10%4.08
=NORM.INV(B4,B2,B3) Explain

95% of calls should finish within about 8.5 minutes; the quickest 10% take under about 4.1.

Example 2 — The middle of the curve

A probability of 0.5 always returns the mean.

=NORM.INV(0.5,6,1.5) Explain

Returns 6.

Common mistakes

  • #NUM! probability is 0 or less, 1 or more, or standard_dev is 0 or negative.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.