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:
-
Numerical values
-
Standard operands (+, -, *, /)
-
Predefined mathematical functions (exp, log, sin, etc.)
-
References to any ReliaSoft Workbooks
Example:
-
BETAINV(0.685470581, 5, 10) = 0.3867687477