GAMMA.INV Function - Returns the inverse value of the gamma distribution in Excel

Buzz

Ngày cập nhật gần nhất: 15/4/2026

This article introduces you to the GAMMA.INV function - one of the widely used statistical functions in Excel.

Description: Returns the inverse value of the gamma distribution, used to study the distribution variables which may be skewed. Supported from Excel 2010 onwards.

Syntax: GAMMA.INV(probability,alpha,beta)

In which:

- probability: Probability associated with the gamma distribution.

- alpha: Parameter value for the distribution.

- beta: Parameter value for the distribution, if beta = 1 -> the function returns the standard gamma distribution.

Note:

- If any of the parameters probability, alpha, beta of the function are not numeric -> the function returns an error value #VALUE!

- If alpha ≤ 0 or beta ≤ 0 -> the function returns an error value #NUM!

- If probability > 1 or probability < 0 -> the function returns an error value #NUM!

Example:

Calculate the inverse value of the GAMMA cumulative distribution of the value in the data table below:

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

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

- In case probability > 1 or probability < 0, the function returns an error value #NUM!

- In case alpha ≤ 0 or beta ≤ 0, the function returns an error value #NUM!

Above is the guide and some specific examples of using the GAMMA.INV function in Excel.

Wishing you all success!

Frequently Asked Questions

What is the purpose of the GAMMA.INV function in Excel?

The GAMMA.INV function in Excel is designed to return the inverse value of the gamma distribution. This function is essential for analyzing variables that may be skewed and is widely utilized in statistical analysis.

How does the syntax for the GAMMA.INV function look in Excel?

The syntax for the GAMMA.INV function in Excel is GAMMA.INV(probability, alpha, beta). Here, 'probability' is the probability associated with the gamma distribution, while 'alpha' and 'beta' are parameters that define the distribution.

What errors can occur when using the GAMMA.INV function in Excel?

When using the GAMMA.INV function, errors may arise if the parameters are not numeric, or if alpha or beta are less than or equal to zero. Additionally, a #NUM! error will occur if the probability is not between 0 and 1.

Can you provide an example of using the GAMMA.INV function in a cell?

To use the GAMMA.INV function, enter the formula =GAMMA.INV(D6,D7,D8) into the desired cell. After pressing Enter, it will return the inverse value of the GAMMA cumulative distribution based on the specified parameters.

Mytour's content is for customer care and travel encouragement only, and we are not responsible.

For errors or inappropriate content, please contact us at: [email protected]