Spread.NET 17 Formula Reference
Formula Functions / Functions D to G / GAMMADIST
In This Topic
    GAMMADIST
    In This Topic

    This function returns the gamma distribution.

    Syntax

    GAMMADIST(x,alpha,beta,cumulative)

    Arguments

    This function has these arguments:

    Argument Description
    x Value at which to evaluate the distribution
    alpha Alpha parameter of the distribution
    beta Beta parameter of the distribution
    cumulative Logical value that determines the form of the function If cumulative is TRUE, then this function returns the cumulative distribution function; if FALSE, it returns the probability mass function.

    Remarks

    The equation for this function is:

    GAMMADIST Equation

    Data Types

    Accepts numeric data for all arguments. Returns numeric data.

    Examples

    GAMMADIST(A5,1,3,FALSE)

    GAMMADIST(R5C1,2,1,TRUE)

    GAMMADIST(4,3,2,TRUE) gives the result 0.3233235838

    GAMMADIST(4,3,2,FALSE) gives the result 0.1353352832

    Version Available

    This function is available in product version 1.0 or later.

    See Also

    BETADIST | GAMMAINV | GAMMALN | KURT | POISSON | Statistical Functions