NORMSDIST
Returns the standard normal cumulative distribution function. The distribution has a mean of 0 (zero) and a standard deviation of one. Use this function in place of a table of standard normal curve areas.
Syntax
NORMSDIST(z)
Z is the value for which you want the distribution.
Remarks
- If z is nonnumeric, NORMSDIST returns the #VALUE! error value.
- The equation for the standard normal density function is:
Example
| Formula | Description (Result) |
|---|---|
| =NORMSDIST(1.333333) | Normal cumulative distribution function at 1.333333 (0.908789) |