# Documentation/Calc Functions/NORM.INV

Jump to navigation Jump to search

NORM.INV

## Category:

Statistical Analysis

## Summary:

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

## Syntax:

NORM.INV(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 NORM.INV(p;m;s) = x then NORM.DIST(x;m;s;TRUE()) = p.
• For values of arguments, Mean=0 and StDev=1, NORM.INV calculates the same value as NORMS.INV, which is the inverse of the standard normal distribution.

## Examples:

Formula Description Returns
=NORM.INV(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
=NORM.INV(0.7;-4.5;1.2) The function calculates the inverse of the cumulative normal distribution for probability equal to 0.7, 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
=NORM.INV(0;-4.5;1.2) The function returns a value error when the probability value is exactly 0 or 1. #VALUE!

None

NORM.INV