SpreadJS 14
Formula Reference / Formula Functions / Compatibility Functions / GAMMAINV
In This Topic
    GAMMAINV
    In This Topic

    This function returns the inverse of the gamma cumulative distribution.

    Syntax

    GAMMAINV(p,alpha,beta)

    Arguments

    This function has these arguments:

    Argument Description
    p Probability
    alpha Alpha parameter of the distribution
    beta Beta parameter of the distribution

    Remarks

    This function calculates the inverse of the F probability distribution, so if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    GAMMAINV(A3,3,4)

    GAMMAINV(0.8902,R3C8,R3C9)

    GAMMAINV(0.75,2,3) gives the result 8.0779035867

    See Also