SpreadJS 13
SpreadJS Documentation / Formula Reference / Formula Functions / GAMMA.INV
In This Topic
    GAMMA.INV
    In This Topic

    This function returns the inverse of the gamma cumulative distribution.

    Syntax

    GAMMA.INV(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 = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. The standard gamma distribution is returned if beta = 1.

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    GAMMA.INV(A3,3,4)

    GAMMA.INV(0.8902,R3C8,R3C9)

    GAMMA.INV(0.75,2,3) gives the result 8.077903586669088