## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

# GAMMA.INV()/GAMMAINV()

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

Definition. This function returns the quantile of the gamma distribution. If p = GAMMA.DIST(x,...) then GAMMA.INV(p,...) = x.

Use this function to examine a variable whose distribution may be skewed.

Arguments

• probability (required). A probability associated with the gamma distribution.

• alpha (required). A parameter of the distribution.

• beta (required). A parameter of the distribution. If beta = 1, GAMMA.INV() returns the standard gamma distribution.

### Note

If one of the arguments isn’t a numeric expression, the GAMMA.INV() function returns the `#VALUE!` error.

If probability is less than 0 or greater than 1, the GAMMA.INV() function returns the `#NUM!` error.

If alpha or beta is less than or equal ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required