Description Computes the normal distribution.
Syntax NORMDIST (x, mean, st_dev, cumulative)
Argument | Description | |
---|---|---|
x | The value at which you want to evaluate the function. | |
mean | The arithmetic mean of the distribution. | |
st_dev | The standard deviation of the distribution. It must be a number greater than 0. | |
cumulative | A logical value indicating the type of computation you want NORMDIST to do. | |
TRUE | The function will return the cumulative area from negative infinity to x. | |
FALSE | The function will return the y value for x. |
Remarks You may use the STANDARDIZE function to "translate" the first three arguments of this function into a form that can be used in the NORMSDIST function.
Equation
Examples This function returns 0.5:
See Also BETADIST, BINOMDIST, CHIDIST, COMBIN, CRITBINOM, FDIST, GAMMADIST, GAMMAINV, NORMINV, NORMSDIST, POISSON