# Documentation/Calc Functions/NORMSDIST

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

NORMSDIST

## Category:

Statistical Analysis

## Summary:

Calculates values of the cumulative distribution function for the standard normal distribution. The standard normal distribution has a mean of zero and a standard deviation of one. It is GAUSS(x)=NORMSDIST(x)-0.5

## Syntax:

NORMSDIST(**Number**)

## Returns:

Returns a real number in the range [0, 1] which is the value of the 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.

## Additional details:

- The formula for NORMSDIST is:

- this is exactly NORMDIST(x;0;1;TRUE()).
- For more details on the standard normal distribution, visit Wikipedia.

## Examples:

Formula | Description | Returns |
---|---|---|

=NORMSDIST(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 |

=NORMSDIST(7.14) | Calculates the cumulative distribution function of the standard normal distribution for the given value. | 0.999999999999533 |

=NORMSDIST(-7.14) | Calculates the cumulative distribution function of the standard normal distribution for the given value. | 4.66654595751322E-13 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

NORMSDIST