NORMDIST( ) function
Returns the probability that a random variable from a normally distributed data set is less than or equal to a specified value, or exactly equal to a specified value.
Syntax
NORMDIST(x, mean, standard_deviation, cumulative)
Parameters
Name | Type | Description |
---|---|---|
x | numeric |
The value for which you want to calculate the probability. |
mean | numeric | The mean value of the data set. |
standard_deviation | numeric |
The standard deviation of the data set. The standard_deviation value must be greater than 0. |
cumulative | logical |
Specify T to calculate the probability that a random variable is less than or equal to x (cumulative probability), or F to calculate the probability that a random variable is exactly equal to x (simple probability). |
Output
Numeric.
Examples
Basic examples
Returns 0.908788780274132:
NORMDIST(42, 40, 1.5, T)
Returns 0.109340049783996:
NORMDIST(42, 40, 1.5, F)