Related Topics:
	Spreadsheet Mathematical Functions Data Entry Tips for 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:

• All arguments must be numerical.

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

• Alpha and Beta must be greater than 1.

Example:

• GAMMAINV(0.068094,9,2) = 10