NORMDIST (normal distribution)

<< 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.

normdist_sample_a     normdist_sample_b

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