BETA.INV function
The BETA.INV function is one of the statistical functions. It is used to return the inverse of the beta cumulative probability density function (BETA.DIST).
Syntax
BETA.INV(probability, alpha, beta, [A], [B])
The BETA.INV function has the following arguments:
| Argument | Description |
|---|---|
| probability | A probability associated with the beta distribution. A numeric value greater than 0 and less than or equal to 1. |
| alpha | The first parameter of the distribution, a numeric value greater than 0. |
| beta | The second parameter of the distribution, a numeric value greater than 0. |
| A | The lower bound to the interval of probability. It is an optional parameter. If it is omitted, the default value of 0 is used. |
| B | The upper bound to the interval of probability. It is an optional parameter. If it is omitted, the default value of 1 is used. |
Notes
How to apply the BETA.INV function.
Examples
The figure below displays the result returned by the BETA.INV function.
