Syntax
NORM.S.DIST(z, cumulative)
| Parameter | Description |
|---|---|
| z | Parameter of the NORM.S.DIST function. |
| cumulative | Parameter of the NORM.S.DIST function. |
Examples
Z-table lookup
Formula
=NORM.S.DIST(1.96, TRUE)
Returns 0.975 — the classic z-table value. 97.5% of the standard normal distribution falls below z=1.96.
P-value for z-test
Formula
=2 * (1 - NORM.S.DIST(ABS(2.15), TRUE))
Returns the two-tailed p-value for a z-score of 2.15. Result of ~0.032 means the result is statistically significant at the 5% level.
Standard normal PDF
Formula
=NORM.S.DIST(0, FALSE)
Returns 0.3989 — the peak height of the standard normal bell curve, which occurs at z=0.
Common Errors
#VALUE!
Non-numeric z value or cumulative is not TRUE/FALSE.
Tips
Replaces z-tables
NORM.S.DIST with cumulative=TRUE gives you the same values as printed z-tables, but with more precision and no need to look things up.
Two-tailed tests
For a two-tailed p-value: =2*(1-NORM.S.DIST(ABS(z),TRUE)). For one-tailed: =1-NORM.S.DIST(z,TRUE) for the upper tail.
Shortcut for NORM.DIST with mean=0, stdev=1
NORM.S.DIST(z, TRUE) is equivalent to NORM.DIST(z, 0, 1, TRUE) but shorter to type.
Try NORM.S.DIST in Viztab
Import your data and use NORM.S.DIST with 370+ other formulas. No signup required.
Open Viztab