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.

  • When used in an event analysis flowchart, the parameters must evaluate to numerical values. They can include:

Example:

  • BETAINV(0.685470581, 5, 10) = 0.3867687477