NORMDIST
Name
Normal distribution
Description
Returns the normal cumulative distribution for the specified mean and standard deviation.
Syntax
NORMDIST(x,mean,stdev,cumulative)
Remarks
If mean = 0 and stdev = 1, this function returns the standard normal distribution, NORMSDIST.
This function has the following arguments:
Argument | Description |
---|---|
x | Value for which to find the distribution |
mean | Arithmetic mean of the distribution |
stdev | Standard deviation of the distribution. Must be greater than zero |
cumulative | Set to TRUE to return the cumulative distribution function. Set to FALSE to return the probability mass function |
Data Type
The x, mean, and stdev arguments accept numeric data. The cumulative argument accepts logical data. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
NORMDIST(10,A3,B17,FALSE)
NORMDIST(10,R3C1,R17C2,FALSE)
NORMDIST(37,41.125,9.86,TRUE)=0.3378810361