GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel

The following article introduces you to the GAMMA.INV function - one of the functions in the statistical function group is very popular in Excel.

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel Picture 1

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:

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel Picture 2

- In the cell to calculate, enter the formula : = GAMMA.INV (D6, D7, D8)

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel Picture 3

- Press Enter -> the inverse value of the GAMMA cumulative distribution is:

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel Picture 4

- Where probability> 1 or probability function returns the #NUM! Error value

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel Picture 5 ;

- Where alpha ≤ 0 or beta ≤ 0 -> the function returns the #NUM! Error value

GAMMA.INV function - The function returns the inverse of the gamma distribution in Excel Picture 6

Above are instructions and some specific examples when using the GAMMA.INV function in Excel.

Good luck!