Documentation/Calc Functions/GAMMA.INV

Function name:
GAMMA.INV

Category:
Statistical Analysis

Summary:
Calculates the inverse of the gamma cumulative distribution function. This function allows you to search for variables with a different distribution.

Syntax:
GAMMA.INV(Number; Alpha; Beta)

Returns:
Returns a non-negative real number is the inverse of the gamma cumulative distribution such that if p = GAMMA.DIST(n;a;b;TRUE) then GAMMA.INV(p;a;b) = n.

Arguments:
Number is a real number or a reference to the cell containing that number which is the probability value for which the inverse gamma distribution is to be calculated. It ranges from 0(inclusive) to 1(exclusive), i.e. [0,1).

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.


 * If Number is less than zero or greater than or equal to 1, then the function returns an error value.
 * If either of Alpha or Beta is negative or zero then the function returns an error value.

Additional details:

 * For more details on the inverse gamma distribution, visit Wikipedia

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

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

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

ODF standard:
Section 6.18.32, part 2

Equivalent Excel functions:
GAMMA.INV