The following article introduces you to the GAMMA.INV function - one of the functions in the statistical function group is very popular in Excel.
Description: The function returns the inverse of the gamma distribution , using this function to study their distribution variables that may be symmetrical . Support functions from Excel 2010 onwards.
Syntax: GAMMA.INV (probability, alpha, beta)
Inside:
- probability: Probability associated with the gamma distribution .
- alpha: The parameter value to the distribution .
- beta: Value The parameter value to the distribution , if beta = 1 -> function returns the standard gamma distribution .
Attention:
- If one of the probability, alpha, and beta arguments of the function is not numeric -> the function returns the #VALUE! Error value
- If alpha ≤ 0 or beta ≤ 0 -> the function returns the #NUM! Error value
- If probability> 1 or probability <0 -> the function returns the #NUM! Error value
For example:
Calculate the inverse value of the GAMMA cumulative distribution of values in the following data table:
- In the cell to calculate, enter the formula : = GAMMA.INV (D6, D7, D8)
- Press Enter -> the inverse value of the GAMMA cumulative distribution is:
- Where probability> 1 or probability function returns the #NUM! Error value
;
- Where alpha ≤ 0 or beta ≤ 0 -> the function returns the #NUM! Error value
Above are instructions and some specific examples when using the GAMMA.INV function in Excel.
Good luck!