NORM.S.INV Function

Returns the z-score at a given probability of the standard normal distribution.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice NORM.S.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.S.INV is the reverse of NORM.S.DIST: give it a probability and it returns the z-score with that share below it.

It's how the well-known critical values are found: 1.645 for 90% two-sided (95% one-sided) confidence, 1.96 for 95% and 2.576 for 99%.

Syntax

=NORM.S.INV(probability) Explain

Arguments

ArgumentRequired?What it does
probabilityYesThe share below the z-score, between 0 and 1 (not including 0 or 1).

Examples

Example 1 — Critical value for 95% confidence

A two-sided 95% interval leaves 2.5% in each tail, so look up 0.975.

B3fx=NORM.S.INV(1-(1-B2)/2)
AB
1MeasureValue
2Confidence0.95
3z1.96
=NORM.S.INV(1-(1-B2)/2) Explain

Returns 1.95996, usually rounded to 1.96.

Example 2 — One-sided 95%

For a one-tailed test, all 5% sits in one tail.

=NORM.S.INV(0.95) Explain

Returns about 1.645.

Common mistakes

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

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.