The BETA.INV function returns the inverse of the cumulative beta probability density function for a given probability.
BETA.INV(
<x>,
<alpha>,
<beta>,
[<A>],
[<B>]
)
- x: Probability associated with the beta distribution.
- alpha: Alpha parameter of the distribution.
- beta: Beta parameter of the distribution.
- A: Optional. Lower limit of the range in which the result of the function can be found.
- B: Optional. Upper limit of the range in which the result of the function can be found.
The BETA.INV function returns a real number.
If any argument is not a number, the function returns a #VALUE! error.
If any argument is not an integer, it is rounded.
If alpha or beta are less than or equal to zero, the function returns an error of type #NUM!.
If the probability does not belong to the interval (0, 1] -that is, if it is less than or equal to zero or greater than one-, the function returns an error of type #NUM.
If the arguments A and B are omitted, the function uses the default values corresponding to a standard cumulative beta distribution function (A = 0 and B = 1).
In this example we want to find the inverse of the beta distribution corresponding to a probability of 0.3660 and parameters alpha = 2 and beta = 3: