Documentation/Calc Functions/NORM.DIST
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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.
Examples:
Formula | Description | Returns |
---|---|---|
=NORM.DIST(7.14;1.5;3.2;1) | Calculates the cumulative distribution function of the normal distribution for the given argument values. | 0.961007571808867 |
=NORM.DIST(7.14;1.5;3.2;0) | Calculates the probability density function of the normal distribution for the given argument values. | 0.026376219058927 |
=NORM.DIST(1;0;0.25;0) | Calculates the probability density function of the normal distribution for the given argument values. | 0.00053532090306 |
=NORM.DIST(-7.14;1.5;3.2;0) | Calculates the probability density function of the normal distribution for the given argument values. | 0.003256542129507 |
=NORM.DIST(7.14;1.5;0;1) | For negative and zero value of StDev the function returns an error value. | Err:502 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
NORM.DIST