# Documentation/Calc Functions/NORMSINV

Jump to navigation
Jump to search

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

## Function name:

NORMSINV

## Category:

Statistical Analysis

## Summary:

Calculates values of the inverse of the cumulative distribution function for the standard normal distribution for the given arguments. The standard normal distribution has a mean of zero and a standard deviation of one.

## Syntax:

NORMSINV(**Number**)

## Returns:

Returns a real number which is the inverse of the cumulative distribution function for the standard normal distribution for the given argument.

## Arguments:

**Number** is a real number between 0 and 1 (both exclusive) or a reference to the cell containing that number which represents the probability value used to determine the inverse standard normal distribution.

- If
**Number**is exactly equal to 0 or 1, then the function returns a value(#VALUE!) error. - If
**Number**is greater than 1 or less than 0, then the function returns an error value.

## Additional details:

- It is such that if NORMSINV(p) = x then NORMDIST(x;0;1;TRUE()) = p or NORMSDIST(x) = p.

## Examples:

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

=NORMSINV(0.7) | The function calculates the inverse of the cumulative standard normal distribution for probability equal to 0.7. Here we can consider that NORMDIST(0.524400512708041;0;1;TRUE()) gives 0.7 also NORMSDIST(0.524400512708041) gives 0.7. | 0.524400512708041 |

=NORMSINV(0) | The function returns a value error when the probability value is exactly 0 or 1. | #VALUE! |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

NORMSINV