Excel functions / Statistics
NORMSDIST function
The chance of a z-score or less in the standard normal distribution. The older form of NORM.S.DIST.
Syntax
=NORMSDIST(z)
Arguments
z: The z-score.
When to use it
NORMSDIST is the older form of NORM.S.DIST(z, TRUE): the share of a standard normal distribution below a z-score.
Examples
Below z = 1.96
A B C 1 z 2 1.96 97.5% In C2:
=NORMSDIST(A2)→ 97.5%
Common mistakes
- Newer form. NORM.S.DIST also gives the height of the curve with FALSE.
NORMSDIST 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: NORMSDIST
- Danish: STANDARDNORMFORDELING
- Dutch: STAND.NORM.VERD
- Finnish: NORM.JAKAUMA.NORMIT
- French: LOI.NORMALE.STANDARD
- German: STANDNORMVERT
- Hungarian: STNORMELOSZL
- Italian: DISTRIB.NORM.ST
- Norwegian: NORMSFORDELING
- Polish: ROZKŁAD.NORMALNY.S
- Portuguese (Brazil): DISTNORMP
- Portuguese (Portugal): DIST.NORMP
- Russian: НОРМСТРАСП
- Spanish: DISTR.NORM.ESTAND
- Swedish: NORMSFÖRD
- Turkish: NORMSDAĞ
Try NORMSDIST in the playground
Related functions
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- NORM.S.INV: The z-score below which a given share of the standard normal distribution falls.