Documentation/Calc Functions/NORMINV

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

NORMDIST

NORM.S.DIST

NORM.S.INV

NORM.DIST

NORM.INV

NORMSDIST

NORMSINV

ODF standard:

Section 6.18.53, part 2

Equivalent Excel functions:

NORMINV