Documentation/Calc Functions/NORMINV

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.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/NORMDIST NORMDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.S.DIST NORM.S.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.S.INV NORM.S.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.DIST NORM.DIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORM.INV NORM.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSDIST NORMSDIST]

[[Special:MyLanguage/Documentation/Calc_Functions/NORMSINV NORMSINV]

ODF standard:
Section 6.18.53, part 2

Equivalent Excel functions:
NORMINV