SpreadJS Documentation
GAMMAINV
SpreadJS Documentation > Formula Reference > Formula Functions > 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

See Also