NORM.DIST (normal distribution)

<< Click to Display Table of Contents >>

NORM.DIST (normal distribution)

Syntax:

NORM.DIST(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

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

Annotation:

The reverse function to this function is NORM.INV

See also:

NORMDIST, NORM.INV/NORMINV, NORM.S.DIST/NORMSDIST, NORM.S.INV/NORMSINV