The `GAMMAINV` function in Excel is used to return the inverse of the gamma cumulative distribution. If `p = GAMMADIST(x, …)`, then `GAMMAINV(p, …) = x`. This function is useful in fields like statistics and probability where you need to work with gamma distributions.
Here is how you use the `GAMMAINV` function:
Syntax
GAMMAINV(probability, alpha, beta)
- probability: The probability associated with the gamma distribution. This is a required parameter and must be a numeric value between 0 and 1 inclusive.
- alpha: This is a parameter of the distribution, also known as the shape parameter. This needs to be a positive numeric value.
- beta: This is another parameter of the distribution, often referred to as the scale parameter. This also needs to be a positive numeric value.
Example
Suppose you want to find the inverse gamma distribution for a probability of 0.5, with an alpha (shape) parameter of 5 and a beta (scale) parameter of 2. You would enter the following formula in Excel:
=GAMMAINV(0.5, 5, 2)
Important Points
- Ensure that the `probability` value is between 0 and 1.
- Both the `alpha` and `beta` parameters must be greater than 0; otherwise, Excel will return an error value `#NUM!`.
- The `GAMMAINV` function was replaced by the `GAMMA.INV` function in Excel 2010 and later for improved consistency with the naming of other related statistical functions, but `GAMMAINV` is still available for compatibility purposes.
Note
- Always remember that Excel’s probability-related functions assume the use of cumulative distribution functions unless stated otherwise.
- Double-check your input values for any potential errors as incorrect input will lead to incorrect results or error messages.
By following the above explanation and tips, you should be able to effectively utilize the `GAMMAINV` function in Excel for your statistical analysis needs.
Unlock Your Potential
Excel
Access
Power BI
