BETA.INV Function Explained
The BETA.INV Function in Microsoft Excel calculates the inverse of the cumulative distribution function for a specified beta distribution. It returns the value of x for a given probability, where x is a value between 0 and 1. It takes three arguments: probability, alpha, and beta.
BETA.INV Function Syntax
BETA.INV(probability, alpha, beta, [A], [B])
- probability: The probability associated with the two-tailed beta distribution.
- alpha: The first shape parameter of the beta distribution.
- beta: The second shape parameter of the 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.