Calculates values of the inverse of the cumulative distribution function for the normal distribution for the given arguments.
NORM.INV(Number; Mean; StDev)
Returns a real number which is the inverse of the cumulative distribution function for the normal distribution for the given 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.
- 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.
|=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!|
Related LibreOffice functions:
Equivalent Excel functions: