Related Topics:
	Spreadsheet Mathematical Functions Function Wizard Functions

BETAINV

Description: Returns the inverse of the cumulative beta probability distribution function for a specified beta distribution. That is, if probability = BETADIST(x,...), then BETAINV(probability,...) = x.

Syntax: BETAINV(Probability, Alpha, Beta)

• Probability is a probability associated with the beta distribution.

• Alpha is a parameter of the distribution.

• Beta is a parameter the distribution.

Remarks:

• All arguments must be numerical.

• Alpha and Beta must be > 0.

• Probability must be > 0 and < 1.

• BETAINV uses an iterative search technique. If the search has not converged after 100 iterations, the function returns an error.

Example:

• BETAINV(0.685470581, 5, 10) = 0.3867687477