Documentation/Calc Functions/NORMSINV

    From The Document Foundation Wiki

    Function name:

    NORMSINV

    Category:

    Statistical Analysis

    Summary:

    Calculates the inverse of the cumulative distribution function for a standard normal distribution.

    The normal distribution is also known as the Gaussian distribution. It is a family of continuous probability distributions used in many fields to represent independent, randomly generated variables. The standard normal distribution is the normal distribution that has a mean of 0 and a standard deviation of 1.

    NORMSINV calculates the real number x such that [math]\displaystyle{ \text{NORMSDIST}(x)~=~p }[/math], where the given probability p lies in the range (0, 1).

    Syntax:

    NORMSINV(Number)

    Returns:

    Returns a real number, which is the value of the random variable that would give the specified probability in the cumulative distribution function for the standard normal distribution.

    Arguments:

    Number is a real number in the range (0, 1), or a reference to a cell containing that number, which is a probability in the cumulative distribution function of the standard normal distribution.

    • If Number is non-numeric, then NORMSINV reports a #VALUE! error.
    • If Number is less than 0.0 or greater than 1.0, then NORMSINV reports an invalid argument error (Err:502).
    • If Number is equal to either 0.0 or 1.0, then NORMSINV reports a #VALUE! error.

    Additional details:

    • Calc's NORMSINV and NORM.S.INV functions perform identical calculations. The requirements for NORMSINV are specified in ODF 1.2 as the LEGACY.NORMSINV function; NORM.S.INV is provided for interoperability with Microsoft Excel.
    • For the standard normal distribution, the following relationship exists between relevant Calc functions:
    [math]\displaystyle{ \text{NORMINV}(x;\:0;\:1)\:=\:\text{NORMSINV}(x) }[/math]

    Examples:

    Formula Description Returns
    =NORMSINV(A1) where cell A1 contains the number 0.5. Here the function calculates the inverse of the given value from the cumulative distribution function for the standard normal distribution. The symmetry of any normal distribution means that the probability density value of 0.5 occurs at the mean value. 0
    =NORMSINV(0.841344746068543) Here the function calculates the inverse of the given value from the cumulative distribution function for the standard normal distribution. Note that the formula =NORMSDIST(1) returns the value 0.841344746068543. 1
    =NORMSINV(0.691462461274013) Here the function calculates the inverse of the given value from the cumulative distribution function for the standard normal distribution. 0.5

    Related LibreOffice functions:

    NORM.DIST

    NORM.INV

    NORM.S.DIST

    NORM.S.INV

    NORMDIST

    NORMINV

    NORMSDIST

    PHI

    ODF standard:

    Section 6.18.55, part 2

    Related (or similar) Excel functions:

    NORMSINV