GAMMA.DIST (gamma distribution)

<< Click to Display Table of Contents >>

GAMMA.DIST (gamma distribution)

Syntax:

GAMMA.DIST(X, Alpha, Beta, Cumulative)

Description:

Returns the probabilities of a gamma distributed random number.

X is the value to be evaluated. Must be ≥ 0.

Alpha and Beta are shape parameters of the function. They both have to be greater than zero.

The logical value Cumulative lets you specify which type of function will be returned:

FALSE: The probability density function is returned.

TRUE: The cumulative distribution function is returned.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

Annotation:

The inverse function is GAMMA.INV

See also:

GAMMADIST, GAMMA.INV/GAMMAINV, GAMMA, GAMMALN