Returns the inverse of the gamma cumulative distribution. If p = GAMMA.DIST(x,...), then GAMMA.INV(p,...) = x. You can use this function to study a variable whose distribution may be skewed.

GAMMA.INV takes 3 required arguments and no optional arguments:

Syntax: GAMMA.INV(probability, alpha, beta)

#1)
The arguments for the GAMMA.INV function are:
Argument Required? Description
probability Required The probability associated with the gamma distribution.
alpha Required A parameter to the distribution.
beta Required A parameter to the distribution. If beta = 1, GAMMA.INV returns the standard gamma distribution.
comments powered by Disqus