# 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