<< Click to Display Table of Contents >> NORMDIST (normal distribution) |
Note: NORMDIST is supplemented by the new identical function NORM.DIST, which is available in newer versions of Microsoft Excel (2010 or later).
Syntax:
NORMDIST(x, Mean, StdDev, Cumulative)
Description:
Returns the normal distribution (also known as Gaussian distribution).
The normal distribution is one of the most important distributions in statistics, since many distributions follow it.
x is the value to be evaluated.
Mean is the mean of LN(x).
StdDev is the standard deviation of LN(x).
The logical value Cumulative lets you specify which type of function will be returned:
FALSE: The probability density function is returned.
TRUE: The cumulative distribution function is returned.
Left: density function ("bell curve"), right: distribution function
Note:
The reverse function to this function is NORMINV
See also:
NORM.DIST, NORM.INV/NORMINV, NORM.S.DIST/NORMSDIST, NORM.S.INV/NORMSINV