NORM.S.DIST Function

Returns the standard normal distribution (mean 0, standard deviation 1).

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice NORM.S.DIST 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.DIST is NORM.DIST for z-scores: the bell curve with mean 0 and standard deviation 1. Turn any value into a z-score with STANDARDIZE, then look up its probability here.

TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.

Syntax

=NORM.S.DIST(z, cumulative) Explain

Arguments

ArgumentRequired?What it does
zYesThe z-score.
cumulativeYesTRUE for the cumulative probability, FALSE for the density (height of the curve).

Examples

Example 1 — What share falls below a z-score?

A z-score of 1.5 means 1.5 standard deviations above the mean.

B3fx=NORM.S.DIST(B2,TRUE)
AB
1MeasureValue
2z-score1.5
3Share below0.9332
4Share above0.0668
=NORM.S.DIST(B2,TRUE) Explain

About 93% of values are below z = 1.5, and about 7% above.

Example 2 — The familiar 2.5%

The share of values more than 1.96 standard deviations below the mean.

=NORM.S.DIST(-1.96,TRUE) Explain

Returns about 0.025 — the lower tail of a 95% interval.

Common mistakes

  • Forgetting cumulative. Use TRUE for a probability; FALSE gives the height of the curve (PHI).

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.