BETAINV Function Explained
The BETAINV Function in Microsoft Excel calculates the inverse of the cumulative distribution function for a specified beta distribution. It returns the value of the inverse distribution for a given probability. It takes four arguments: probability, alpha, beta, and A. Probability is the probability associated with the beta distribution. Alpha and beta are the shape parameters of the beta distribution. A is an optional argument that specifies the lower bound of the distribution.
BETAINV Function Syntax
BETAINV(probability, alpha, beta, A, B)
- probability: The probability associated with the two-tailed beta distribution.
- alpha: The alpha parameter of the two-tailed beta distribution.
- beta: The beta parameter of the two-tailed beta distribution.
- A: The lower bound of the interval for which you want a probability.
- B: The upper bound of the interval for which you want a probability.