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

Want to practice GAUSS in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=GAUSS(z) Explain

Arguments

ArgumentRequired?What it does
zYesThe 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.

B2fx=GAUSS(1)
AB
1MeasureValue
2Mean to +1 sd0.3413
3Within ±1 sd0.6827
4Within ±2 sd0.9545
=GAUSS(1) Explain

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.

=GAUSS(-1.5) Explain

Returns about −0.4332.

Common mistakes

  • #VALUE! z isn't a number.

Notes

Kyle Stott

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.