This function returns the cumulative normal distribution for the specified mean and standard deviation. If mean = 0 and standard_dev = 1, the function returns the standard normal distribution.
Syntax:
NORMDIST(value, mean, standard_dev)
This function is related to the NORMINV function in the following way:
If prob = normdist(value, m, sd), then norminv(prob, m, sd) = value.
Arguments:
| Argument | Description |
|---|---|
| value | The value at which you want to evaluate the distribution. |
| mean | A value stating the arithmetic mean for the distribution. |
| standard_dev | A positive value stating the standard deviation of the distribution. |
Limitations:
All arguments must be numeric, else NULL will be returned.