# Documentation/Calc Functions/NORMINV

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

## Function name:

NORMINV

## Category:

Statistical Analysis

## Summary:

Calculates values of the inverse of the cumulative distribution function for the normal distribution for the given arguments.

## Syntax:

NORMINV(**Number**; **Mean**; **StDev**)

## Returns:

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

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

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

- 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. - If
**StDev**is negative or zero then the function returns an error value.

## Additional details:

- It is such that if NORMINV(x;m;s) = p then NORMDIST(p;m;s;TRUE()) = x.
- For values of arguments,
**Mean**=0 and**StDev**=1, NORMINV calculates the same value as NORMSINV, which is the inverse of the standard normal distribution.

## Examples:

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

=NORMINV(0.9;63;5) | If the average egg weighs 63 grams with a standard deviation of 5, then there will be 90% probability that the egg will not be heavier than approximately 69.41 grams | 69.407757827723 |

=NORMINV(0.7;-4.5;1.2) | The function calculates the inverse of the cumulative normal distribution for probability equal to 0.5, mean -4.5 and standard deviation 1.2. Here we can consider that NORM.DIST(-3.87071938475035;-4.5;1.2;TRUE()) gives 0.7 | -3.87071938475035 |

=NORMINV(0;-4.5;1.2) | The function returns a value error when the probability value is exactly 0 or 1. | #VALUE! |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

NORMINV