Spread Formula Reference
GAMMAINV
Formula Functions > Functions D to G > GAMMAINV

This function returns the inverse of the gamma cumulative distribution.

Syntax

GAMMAINV(p,alpha,beta)

Arguments

This function has these arguments:

Argument Description
p Probability
alpha Alpha parameter of the distribution
beta Beta parameter of the distribution

Remarks

This function calculates the inverse of the F probability distribution, so if p = GAMMADIST(x,...), then GAMMAINV(p,...) = x.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

GAMMAINV(A3,3,4)

GAMMAINV(0.8902,R3C8,R3C9)

GAMMAINV(0.75,2,3) gives the result 8.0779035867

Version Available

This function is available in product version 1.0 or later.

See Also

GAMMADIST | GAMMALN | Statistical Functions