Excel functions / Statistics
NORM.S.DIST function
The standard normal distribution (mean 0, standard deviation 1) at a z-score.
Syntax
=NORM.S.DIST(z, cumulative)
Arguments
z: The z-score.cumulative: TRUE for the chance of z or less; FALSE for the height of the curve.
When to use it
NORM.S.DIST is the normal distribution with a mean of 0 and a standard deviation of 1. Give it a z-score and TRUE to get the share of values below it.
Examples
Below a z-score of 1.96
A B C 1 z 2 1.96 97.5% In C2:
=NORM.S.DIST(A2, TRUE)→ 97.5%Within one standard deviation of the mean
A B C 1 z 2 1 68.3% In C2:
=NORM.S.DIST(A2, TRUE)-NORM.S.DIST(-A2, TRUE)→ 68.3%
Common mistakes
- A raw value, not a z-score. Convert the value first with STANDARDIZE, or use NORM.DIST with the mean and standard deviation.
NORM.S.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.S.DIST
- Danish: STANDARD.NORM.FORDELING
- Dutch: NORM.S.VERD
- Finnish: NORM_JAKAUMA.NORMIT
- French: LOI.NORMALE.STANDARD.N
- German: NORM.S.VERT
- Hungarian: NORM.S.ELOSZLÁS
- Italian: DISTRIB.NORM.ST.N
- Norwegian: NORM.S.FORDELING
- Polish: ROZKŁ.NORMALNY.S
- Portuguese (Brazil): DIST.NORMP.N
- Portuguese (Portugal): DIST.S.NORM
- Russian: НОРМ.СТ.РАСП
- Spanish: DISTR.NORM.ESTAND.N
- Swedish: NORM.S.FÖRD
- Turkish: NORM.S.DAĞ
Try NORM.S.DIST in the playground
Related functions
- NORM.S.INV: The z-score below which a given share of the standard normal distribution falls.
- NORM.DIST: The normal distribution: the chance of a value at or below x, or the height of the bell curve at x.
- STANDARDIZE: A z-score: how many standard deviations a value is above (or below) the mean.
- PHI: The height of the standard normal bell curve at x.