Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

GAMMAINV

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

Syntax: GAMMAINV(Probability, Alpha, Beta)

• Probability is the probability associated with the gamma distribution.

• Alpha is a parameter to the distribution.

• Beta is a parameter to the distribution. If Beta = 1, GAMMAINV returns the standard gamma distribution.

Remarks:

• Arguments must be numeric.

• Probability must be => 0 and <= 1.

• Alpha and Beta must be greater than 1.

Example:

• GAMMAINV(0.068094,9,2) = 10

© 1992-2013. ReliaSoft Corporation. ALL RIGHTS RESERVED.