The Excel GAMMAINV Function

GAMMADIST and GAMMAINV

The Gammainv function is the inverse of the Excel Gammadist function (when used to calculate the cumulative distribution function).

I.e. for a supplied probability, P, the Gammainv function returns the value of x such that:

P = Gammadist( x, alpha, beta, TRUE )
GAMMAINV and GAMMA.INV Functions

In Excel 2010, the Gammainv function has been replaced by the Gamma.Inv function, which has improved accuracy.

Although it has been replaced, the Gammainv function is still available in Excel 2010 (stored in the list of compatibility functions), to allow compatibility with earlier versions of Excel.

Related Function:
GAMMADIST

Function Description

The Excel Gammainv function returns the inverse of the Gamma Cumulative Distribution.

The syntax of the function is:

GAMMAINV( probability, alpha, beta )

where the function arguments are:

probability-The probability value for which you want to evaluate the inverse Gamma Cumulative Distribution Function (must be between 0 & 1).
alpha-A parameter of the distribution.
beta-

A parameter of the distribution.

(Note: if beta=0, then this specifies the Standard Gamma Distribution).


Gammainv Function Example

The charts below show the Gamma Cumulative Distribution and the Inverse Gamma Cumulative Distribution, with the parameter alpha set to 3 and the parameter beta set to 2.

Plot of the Gamma Cumulative Distribution Function with α = 3 and β = 2
Gamma Cumulative Distribution Function with α=3 & β=2
Plot of the Inverse Gamma Cumulative Distribution Function with α = 3 and β = 2
Inverse Gamma Cumulative Distribution with α=3 & β=2

If you want to calculate the value of the Inverse Gamma Cumulative Distribution for the probability 0.5, this can be done using the Excel Gammainv function, as follows:

= GAMMAINV( 0.5, 3, 2 )

This gives the result 5.348120627.


For further examples of the Excel Gammainv function, see the Microsoft Office website.


Gammainv Function Errors

If you get an error from the Excel Gammainv function this is likely to be one of the following:

Common Errors
#NUM!-

Occurs if either:

  • The supplied probability value is < 0 or ≥ 1;
  • The supplied alpha ≤ 0 or the supplied beta ≤ 0.
#N/A-Occurs if Excel fails to converge to a solution after 100 iterations. Excel is unable to calculate the solution.
#VALUE!-Occurs if any of the supplied arguments is non-numeric.