GAUSS Function
Returns the probability of a value falling between the mean and z standard deviations from it.
Category
Statistical
Available in
Excel 2013+, Microsoft 365
Returns
A number
Overview
GAUSS returns the area under the standard bell curve between the middle (0) and z — that is, NORM.S.DIST(z,TRUE) − 0.5.
Double it to get the share within ±z standard deviations of the mean: the 68–95–99.7 rule.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| z | Yes | The number of standard deviations from the mean. |
Examples
Example 1 — The 68–95 rule
Doubling GAUSS gives the share within ±1 and ±2 standard deviations.
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | Mean to +1 sd | 0.3413 |
| 3 | Within ±1 sd | 0.6827 |
| 4 | Within ±2 sd | 0.9545 |
About 68% of values fall within one standard deviation of the mean, and about 95% within two.
Example 2 — Negative z
Below the mean, the result is negative.
Returns about −0.4332.
Common mistakes
- #VALUE! z isn't a number.
Notes
- Related functions: NORM.S.DIST, PHI, STANDARDIZE.

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.