Statistical - GAMMA.INV Function

Description

The GAMMA.INV function returns the inverse of the gamma cumulative distribution.

If p = GAMMA.DIST(x...), then GAMMA.INV (p...) = x. You can use this Function to study a variable whose distribution may be skewed.

Syntax

GAMMA.INV (probability,alpha,beta)

Arguments

A parameter to the distribution.

If beta = 1, GAMMA.INV returns the standard gamma distribution.

Argument Description Required/ Optional
Probability The probability associated with the gamma distribution. Required
Alpha A parameter to the distribution. Required
Beta Required

Notes

  • If any argument is text, GAMMA.INV returns the #VALUE! error value.

  • If probability < 0 or probability > 1, GAMMA.INV returns the #NUM! error value.

  • If alpha ≤ 0 or if beta ≤ 0, GAMMA.INV returns the #NUM! error value.

  • Given a value for probability, GAMMA.INV seeks that value x such that

    $$GAMMA.DIST(x, alpha, beta, TRUE) = probability$$

Thus, precision of GAMMA.INV depends on precision of GAMMA.DIST. GAMMA.INV uses an iterative search technique. If the search has not converged after 64 iterations, the function returns the #N/A error value.

Applicability

Excel 2010, Excel 2013, Excel 2016

Example

Gamma Inv Function
advanced_excel_statistical_functions.htm
Advertisements