Navigation:  Formula Reference > Spreadsheet Formula Functions >

GAMMAINV

Previous pageReturn to chapter overviewNext page

 

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

 

See Also

GAMMADIST

GAMMALN