Documentation/Calc Functions/NORM.S.INV

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

NORM.S.INV

Category:

Statistical Analysis

Summary:

Calculates values of the inverse of the cumulative distribution function for the standard normal distribution for the given arguments. The standard normal distribution has a mean of zero and a standard deviation of one.

Syntax:

NORM.S.INV(Number)

Returns:

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

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

Additional details:

  • It is such that if NORM.S.INV(p) = x then NORM.DIST(x;0;1;TRUE()) = p or NORM.S.DIST(x) = p.

Examples:

Formula Description Returns
=NORM.S.INV(0.7) The function calculates the inverse of the cumulative standard normal distribution for probability equal to 0.7. Here we can consider that NORM.DIST(0.524400512708041;0;1;TRUE()) gives 0.7 0.524400512708041
=NORM.S.INV(0) The function returns a value error when the probability value is exactly 0 or 1. #VALUE!

Related LibreOffice functions:

NORMDIST

NORM.S.DIST

NORM.INV

NORM.DIST

NORMINV

NORMSDIST

NORMSINV

ODF standard:

None

Equivalent Excel functions:

NORM.S.INV