Navigation:  Formula Reference > Spreadsheet Formula Functions >

GAMMA.INV

Previous pageReturn to chapter overviewNext page

 

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