NORMDIST
The NORMDIST function returns the normal distribution of the specified function form.
NORMDIST(num, average, stdev, form-type)
num: The number value to be evaluated.
average: A number value representing the known average (arithmetic mean) rate at which events occur.
stdev: A number value representing the standard deviation of the population. stdev must be greater than 0.
form-type: A modal value that indicates which form of the exponential function to provide.
cumulative form (TRUE or 1): Return the value of the cumulative distribution form.
probability density form (FALSE or 0): Return the value of the probability density form.
Notes
If average is 0, stdev is 1, and form-type is TRUE, NORMDIST returns the same value as the cumulative standard normal distribution returned by NORMSDIST.
Examples |
---|
=NORMDIST(22, 15, 2.5, 1) returns 0.997444869669572, the cumulative distribution form. =NORMDIST(22, 15, 2.5, 0) returns 0.00316618063319199, the probability density form. |