GAMMADIST (gamma distribution)

<< Click to Display Table of Contents >>

GAMMADIST (gamma distribution)

Note: GAMMADIST is supplemented by the new identical function GAMMA.DIST, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

GAMMADIST(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.

See also:

GAMMA.DIST, GAMMA.INV/GAMMAINV, GAMMA, GAMMALN