Documentation/Calc Functions/NORM.DIST

Function name:
NORM.DIST

Category:
Statistical Analysis

Summary:
Calculates values of the probability density function or cumulative distribution function for the normal distribution for the given arguments.

Syntax:
NORM.DIST(Number; Mean; StDev; C)

Returns:
Returns a real number in the range [0, 1] which is the value of the probability density function or cumulative distribution function for the normal distribution for the given arguments.

Arguments:
Number is a real number or a reference to the cell containing that number which is the value for which the normal distribution is to be calculated.

Mean is a real number or a reference to the cell containing that number which is the mean value of the normal distribution.

StDev is a positive real number or a reference to the cell containing that number which is the standard deviation of the normal distribution.

C can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.


 * If StDev is negative or zero then the function returns an error value.

Additional details:

 * For values of arguments, Mean=0 and StDev=1, NORM.DIST calculates the same value as NORM.S.DIST, which is the standard normal distribution.
 * The formula for NORM.DIST is:

If C is FALSE, NORM.DIST returns the probability density function value

If C is TRUE, NORM.DIST returns the cumulative distribution function value
 * For more details on the normal distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/NORM.INV NORM.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.S.DIST NORM.S.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.S.INV NORM.S.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMDIST NORMDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMINV NORMINV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSDIST NORMSDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSINV NORMSINV]

ODF standard:
None

Equivalent Excel functions:
NORM.DIST