Sunday, April 04, 2010

Excel Normal Distribution Formulas

=NORMDIST(x, mean, stdev, cumulative)

Returns the normal cumulative distribution for the specified mean and standard deviation.

=NORMSDIST(z)

Returns the standard normal cumulative distribution (has a mean of zero and a standard deviation of one)

=NORMSINV(p)

Returns the inverse of the standard normal cumulative distribution (has a mean of zero and a standard deviation of one)

No comments:

Post a Comment

Do provide your constructive comment. I appreciate that.