NORM.DIST Function

Returns the normal distribution for a given mean and standard deviation.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice NORM.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.DIST works with the bell curve. Give it a value, the average and the standard deviation, and it tells you how likely it is to get that value or less.

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.

For the probability above a value, use 1 − NORM.DIST(…, TRUE); between two values, subtract one cumulative result from the other.

Syntax

=NORM.DIST(x, mean, standard_dev, cumulative) Explain

Arguments

ArgumentRequired?What it does
xYesThe value to evaluate.
meanYesThe average of the distribution.
standard_devYesThe standard deviation; must be greater than 0.
cumulativeYesTRUE for the cumulative probability, FALSE for the density (height of the curve).

Examples

Example 1 — How many calls finish within 8 minutes?

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

B5fx=NORM.DIST(B4,B2,B3,TRUE)
AB
1MeasureValue
2Average (min)6
3Std deviation1.5
4Call length8
5P(8 min or less)0.9088
6P(more than 8)0.0912
=NORM.DIST(B4,B2,B3,TRUE) Explain

About 91% of calls finish within 8 minutes, so roughly 9% run longer.

Example 2 — Between two values

The share of calls lasting 5 to 7 minutes.

=NORM.DIST(7,6,1.5,TRUE)-NORM.DIST(5,6,1.5,TRUE) Explain

Returns about 0.495 — just under half.

Example 3 — Height of the curve

With FALSE, NORM.DIST returns the density, used for drawing the bell curve on a chart.

=NORM.DIST(8,6,1.5,FALSE) Explain

Returns about 0.1093.

Common mistakes

  • Forgetting cumulative. The last argument has no default. TRUE is almost always what you want for a probability.
  • #NUM! standard_dev is 0 or negative.
  • Not every dataset is bell-shaped. Skewed data (such as order values or wait times) can give misleading results. Check a histogram first.

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.