Excel functions / Statistics
GAUSS function
The chance that a standard normal value falls between the mean and z standard deviations above it.
Syntax
=GAUSS(z)
Arguments
z: The z-score.
When to use it
GAUSS gives the share of a standard normal distribution between the mean and a z-score: NORM.S.DIST(z, TRUE) minus 0.5.
Examples
Between the mean and 2 standard deviations
A B C 1 z 2 2 47.7% In C2:
=GAUSS(A2)→ 47.7%
Common mistakes
- One side only. For both sides, double it.
GAUSS 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: GAUSS
- Danish: GAUSS
- Dutch: GAUSS
- Finnish: GAUSS
- French: GAUSS
- German: GAUSS
- Hungarian: GAUSS
- Italian: GAUSS
- Norwegian: GAUSS
- Polish: GAUSS
- Portuguese (Brazil): GAUSS
- Portuguese (Portugal): GAUSS
- Russian: ГАУСС
- Spanish: GAUSS
- Swedish: GAUSS
- Turkish: GAUSS
Related functions
- NORM.S.DIST: The standard normal distribution (mean 0, standard deviation 1) at a z-score.
- PHI: The height of the standard normal bell curve at x.