Syntax
NORMSDIST(z)
| Parameter | Description |
|---|---|
| z | Parameter of the NORMSDIST function. |
Examples
Cumulative probability at z=1
Formula
=NORMSDIST(1)
Returns 0.8413 — 84.13% of the standard normal distribution falls below z=1.
Probability between two z-values
Formula
=NORMSDIST(1) - NORMSDIST(-1)
Returns 0.6827 — the probability of falling within one standard deviation of the mean (the 68% rule).
Upper tail probability
Formula
=1 - NORMSDIST(2.33)
Returns ~0.01 — only about 1% of the distribution lies above z=2.33.
Common Errors
#VALUE!
Non-numeric input.
Tips
CDF only — no PDF option
NORMSDIST always returns the cumulative probability. For the probability density function, use NORM.S.DIST(z, FALSE).
Use NORM.S.DIST instead
NORMSDIST is a compatibility function. NORM.S.DIST is the modern replacement with an additional cumulative argument.
Common z-values
NORMSDIST(1.645)=0.95, NORMSDIST(1.96)=0.975, NORMSDIST(2.326)=0.99. These are the critical values for 90%, 95%, and 99% one-tailed tests.
Try NORMSDIST in Viztab
Import your data and use NORMSDIST with 370+ other formulas. No signup required.
Open Viztab