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

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    GAMMADIST | GAMMALN | Statistical Functions