GAUSS function
GAUSS returns the probability that a standard normal value lies between 0 and z, the area under the curve from the mean out to z. It is 0.5 less than the cumulative NORM.S.DIST.
Example
Read it as a sentence: find how much of a standard bell curve lies between the middle and 1 standard deviation above it, which gives 0.341344746.
A
B
C
D
1
0.341344746
2
3
Syntax
GAUSS(z)
-
z(required) - A standard normal z-score.
Returns: The probability that a standard normal value lies between 0 and z.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=GAUSS(1) | 0.341344746 | Working example |
=GAUSS("1") | 0.341344746 | Text-number in first arg |
=GAUSS({1,1}) | 0.341344746 | Array in first arg (lifts, spills) |
=GAUSS(-1) | -0.341344746 | Negative |
=GAUSS(0) | 0 | Zero |
=GAUSS(40) | 0.5 | Large |
=GAUSS("abc") | #VALUE! | Non-numeric text in first arg |
=GAUSS(NA()) | #N/A | Error in first arg |
Watch out for
- Equals NORM.S.DIST(z,TRUE) minus 0.5.
- Negative z gives a negative result.
Where it works
- Excel
- GAUSS arrived in Excel 2013. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .