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