Documentation/Calc Functions/NORM.S.INV

    From The Document Foundation Wiki

    Function name:

    NORM.S.INV

    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.

    NORM.S.INV calculates the real number x such that [math]\displaystyle{ \text{NORM.S.DIST}(x;\:1)~=~p }[/math], where the given probability p lies in the range (0, 1).

    Syntax:

    NORM.S.INV(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 NORM.S.INV reports a #VALUE! error.
    • If Number is less than 0.0 or greater than 1.0, then NORM.S.INV reports an invalid argument error (Err:502).
    • If Number is equal to either 0.0 or 1.0, then NORM.S.INV 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; 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{NORM.INV}(x;\:0;\:1)\:=\:\text{NORM.S.INV}(x) }[/math]
    • The name space for NORM.S.INV is COM.MICROSOFT.NORM.S.INV.
    • For more information on the standard normal distribution, visit Wikipedia's Standard normal distribution page.

    Examples:

    Formula Description Returns
    =NORM.S.INV(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
    =NORM.S.INV(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 =NORM.S.DIST(1; 1) returns the value 0.841344746068543. 1
    =NORM.S.INV(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

    NORMDIST

    NORMINV

    NORMSDIST

    NORMSINV

    PHI

    ODF standard:

    None

    Related (or similar) Excel functions:

    NORM.S.INV