Spread WPF 17
Spread WPF Documentation / Formula Reference / Formula Functions / NORMINV
In This Topic
    NORMINV
    In This Topic

    Summary

    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

    See Also