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 ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.