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:
This returns the normal distribution (also known as Gaussian distribution).
The normal distribution is one of the most important distributions in statistics, since many random variables are normally distributed or are at least approximately normally distributed.
x is the value to be evaluated.
Mean is the mean of LN(x).
StdDev is the standard deviation of LN(x).
You use the logical value Cumulative to 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
Additional info:
The reverse function to this function is NORMINV
See also:
NORM.DIST, NORM.INV/NORMINV, NORM.S.DIST/NORMSDIST, NORM.S.INV/NORMSINV