Documentation/Calc Functions/NORM.S.DIST
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
NORM.S.DIST
Category:
Statistical Analysis
Summary:
Calculates values of the probability density function or cumulative distribution function for the standard normal distribution. The standard normal distribution has a mean of zero and a standard deviation of one.
Syntax:
NORM.S.DIST(Number; Cumulative)
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 standard normal distribution for the specified value.
Arguments:
Number is a real number or a reference to the cell containing that number which is the value for which the standard normal distribution is to be calculated.
Cumulative 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.
Additional details:
- The formula for NORM.S.DIST is:
If Cumulative is FALSE(), NORM.S.DIST returns the probability density function value
If Cumulative is TRUE(), NORM.S.DIST returns the cumulative distribution function value
- For more details on the standard normal distribution, visit Wikipedia.
Examples:
Formula | Description | Returns |
---|---|---|
=NORM.S.DIST(1;0) | The function calculates the probability density function of the standard normal distribution for the given value. | 0.241970724519143 |
=NORM.S.DIST(1;1) | The area below the standard normal distribution curve to the left of X value 1 is around 84% of the total area. | 0.841344746068543 |
=NORM.S.DIST(7.14;1) | The function calculates the cumulative distribution function of the standard normal distribution for the given value. | 0.999999999999533 |
=NORM.S.DIST(-7.14;1) | The function calculates the cumulative distribution function of the standard normal distribution for the given value. | 4.66654595751322E-13 |
Related LibreOffice functions:
ODF standard:
None
Equivalent Excel functions:
NORM.S.DIST