Spread.Sheets Documentation
GAMMA.INV
Spread.Sheets Documentation > Formula Reference > Formula Functions > GAMMA.INV

This function returns the inverse of the gamma cumulative distribution.

Syntax

GAMMA.INV(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 = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. The standard gamma distribution is returned if beta = 1.

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

GAMMA.INV(A3,3,4)

GAMMA.INV(0.8902,R3C8,R3C9)

GAMMA.INV(0.75,2,3) gives the result 8.077903586669088