NORM.S.DIST function
NORM.S.DIST turns a z-score into a probability on the standard normal curve, which has a mean of 0 and a standard deviation of 1. It is a usual step in hypothesis testing.
Example
Read it as a sentence: find the cumulative chance of a standard normal value at or below 1.96, which gives 0.975002105.
A
B
C
D
1
0.975002105
2
3
Syntax
NORM.S.DIST(z, cumulative)
-
z(required) - The z-score (standard deviations from the mean).
-
cumulative(required) - TRUE for the area to the left of z, FALSE for the curve height at z.
Returns: The standard normal probability or density at 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 |
|---|---|---|
=NORM.S.DIST(1.96,TRUE) | 0.975002105 | Working example |
=NORM.S.DIST(1.96,FALSE) | 0.058440944 | Other cumulative flag |
=NORM.S.DIST(1.96,0) | 0.058440944 | Cumulative as 0 |
=NORM.S.DIST("1.96",TRUE) | 0.975002105 | Text-number in first arg |
=NORM.S.DIST({1.96,1.96},TRUE) | 0.975002105 | Array in first arg (lifts, spills) |
=NORM.S.DIST(40,TRUE) | 1 | Large z |
=NORM.S.DIST("abc",TRUE) | #VALUE! | Non-numeric text in first arg |
=NORM.S.DIST(NA(),TRUE) | #N/A | Error in first arg |
Watch out for
- The second argument is required here, unlike the old NORMSDIST.
- z of 1.96 returns about 0.975 when cumulative.
Where it works
- Excel
- NORM.S.DIST arrived in Excel 2010. 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 .