Spread Formula Reference
Formula Functions / Functions M to Q / NORMSINV
In This Topic
    NORMSINV
    In This Topic

    This function returns the inverse of the standard normal cumulative distribution. The distribution has a mean of zero and a standard deviation of one.

    Syntax

    NORMSINV(prob)

    Arguments

    The argument is the probability for the normal distribution.

    Data Types

    Accepts numeric data. Returns numeric data.

    Examples

    NORMSINV(A3)

    NORMSINV(R1C2)

    NORMSINV(0.9244) gives the result 1.43530571453713

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    NORMINV | NORMSDIST | Statistical Functions