Excel functions / Statistics
NORM.DIST function
The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
Syntax
=NORM.DIST(x, mean, standard_dev, cumulative)
Arguments
x: The value.mean: The average of the distribution.standard_dev: Its standard deviation.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve.
When to use it
NORM.DIST works with the normal (bell curve) distribution. With TRUE it gives the chance of a value at or below x; with FALSE the height of the curve at x. Give it the mean and standard deviation.
Examples
Share of people under 180 cm, if heights average 170 with SD 8
A B C D E 1 Height Mean SD 2 180 170 8 89.4% In E2:
=NORM.DIST(A2, B2, C2, TRUE)→ 89.4%Share between 160 and 180
A B C D 1 Mean SD 2 170 8 78.9% In D2:
=NORM.DIST(180, A2, B2, TRUE)-NORM.DIST(160, A2, B2, TRUE)→ 78.9%
Common mistakes
- Forgetting TRUE. Without TRUE the result is the height of the curve, a small number that is not a probability.
NORM.DIST 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.DIST
- Dutch: NORM.VERD.N
- Finnish: NORMAALI.JAKAUMA
- French: LOI.NORMALE.N
- German: NORM.VERT
- Hungarian: NORM.ELOSZLÁS
- Italian: DISTRIB.NORM.N
- Norwegian: NORM.FORDELING
- Polish: ROZKŁ.NORMALNY
- Portuguese (Brazil): DIST.NORM.N
- Portuguese (Portugal): DIST.NORMAL
- Russian: НОРМ.РАСП
- Spanish: DISTR.NORM.N
- Swedish: NORM.FÖRD
- Turkish: NORM.DAĞ
Also written as NORMDIST.
Try NORM.DIST in the playground
Related functions
- NORM.INV: The value below which a given share of a normal distribution falls.
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- STANDARDIZE: A z-score: how many standard deviations a value is above (or below) the mean.
- BINOM.DIST: The chance of a number of successes in a set number of tries, each with the same chance.