GAMMA_INV

GAMMA_INV(arg1, arg2, arg3) → { number }

Returns the inverse of the gamma cumulative distribution: if p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x.

Parameters:

Name Type Description
arg1 number

The probability associated with the gamma distribution, a number between 0 and 1, inclusive.

arg2 number

The alpha parameter of the distribution, a positive number.

arg3 number

The beta parameter of the distribution, a positive number. If this parameter is equal to 1, the function returns the standard gamma distribution.

Returns:

Type
number