NORMDIST(x, mean, stdev)

The NORMDIST function calculates the normal distribution for a given mean and standard deviation (stdev), where x is the value for which you want to know the distribution. The formula used is:

image\ebx_700103530.gif

NORMDIST calculates the probability mass function.

For example:

NORMDIST(3, 2, 1)

returns 0.242, which is the probability of the event x = 3, given a normal distribution with a mean of 2 and standard deviation 1.

See also:

Other statistical functions