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

    This function returns the inverse of the normal cumulative distribution for the given mean and standard deviation.

    Syntax

    NORMINV(prob,mean,stdev)

    Arguments

    This function has these arguments:

    Argument Description
    prob Probability of the normal distribution
    mean Arithmetic mean of the distribution
    stdestdev Standard deviation of the distribution Must be greater than zero.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    NORMINV(B3,C12,D14)

    NORMINV(R3C2,R12C3,R14C4)

    NORMINV(0.978,32,0.252) gives the result 32.50755174

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    NORMDIST | NORMSINV | Statistical Functions