Documentation/Calc Functions/GAMMA.DIST

Function name:
GAMMA.DIST

Category:
Statistical Analysis

Summary:
Calculates the value of the probability density function or the cumulative distribution function for the gamma distribution.

Syntax:
GAMMA.DIST(Number; Alpha; Beta; C)

Returns:
Returns a real number which is a value of the probability density function or the cumulative distribution function for the Gamma distribution. Its value ranges from 0 to 1, i.e. [0,1].

Arguments:
Number is a real number or a reference to the cell containing that number for which the gamma distribution is to be calculated.

Alpha is a real number or a reference to the cell containing that number which is the alpha (shape) parameter for the gamma distribution.

Beta is a real number or a reference to the cell containing that number which is the beta (rate) parameter for the gamma distribution.

C can be 0 or False to calculate the probability density function. It can be any other value or True to calculate the cumulative distribution function.


 * If either of Alpha or Beta is negative or zero then the function returns an error value.
 * If Number is negative then the function returns an error value.

Additional details:
If C is FALSE, GAMMA.DIST returns 0 if x=0, an error value if x<0 and the probability density function value
 * The formula for GAMMA.DIST is:

If C is TRUE, GAMMA.DIST returns 0 if x=0, an error value if x<0 and the cumulative distribution function value
 * For more details on gamma distribution, visit Wikipedia.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/GAMMA.INV GAMMA.INV]

[[Special:MyLanguage/Documentation/Calc_Functions/GAMMADIST GAMMADIST]

[[Special:MyLanguage/Documentation/Calc_Functions/GAMMAINV GAMMAINV]

ODF standard:
None

Equivalent Excel functions:
GAMMA.DIST