# Documentation/Calc Functions/NORMDIST

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

## 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.

## Examples:

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

=NORMDIST(7.14;1.5;3.2) | Calculates the cumulative distribution function(default value is TRUE()) of the normal distribution for the given argument values. | 0.961007571808867 |

=NORMDIST(7.14;1.5;3.2;1) | Calculates the cumulative distribution function of the normal distribution for the given argument values. | 0.961007571808867 |

=NORMDIST(7.14;1.5;3.2;0) | Calculates the probability density function of the normal distribution for the given argument values. | 0.026376219058927 |

=NORMDIST(1;0;0.25;0) | Calculates the probability density function of the normal distribution for the given argument values. | 0.00053532090306 |

=NORMDIST(-7.14;1.5;3.2;0) | Calculates the probability density function of the normal distribution for the given argument values. | 0.003256542129507 |

=NORMDIST(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:

## Equivalent Excel functions:

NORMDIST