Documentation/Calc Functions/NORMDIST

Function name:
NORMDIST

Category:
Statistical Analysis

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

Syntax:
NORMDIST(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. By default, its value is TRUE hence the function calculates the cumulative distribution function if this argument is not passed.


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

Additional details:

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

If C is FALSE, NORMDIST returns the probability density function value

If C is TRUE, NORMDIST returns the cumulative distribution function value
 * For more details on the ormal 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/NORM.DIST NORM.DIST]

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

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

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

ODF standard:
Section 6.18.52, part 2

Equivalent Excel functions:
NORMDIST