Spread Formula Reference
Formula Functions / Functions D to G / 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

    Version Available

    This function is available in Spread for Windows Forms 11.0 or later.

    See Also

    GAMMA