This function calculates the inverse of the cumulative beta density function.
BETA.INV(prob,alpha,beta,lower,upper)
This function has these arguments:
| Argument | Description |
|---|---|
| prob | Probability of the distribution |
| alpha | Alpha parameter of the distribution |
| beta | Beta parameter of the distribution |
| lower | [Optional] Lower bound of the interval for x; 0 if omitted |
| upper | [Optional] Upper bound of the interval for x; 1 if omitted |
If you omit values for upper and lower, the calculation uses the standard cumulative beta distribution, so that lower is zero and upper is one. This function returns the #VALUE! error value if any argument is nonnumeric.
Accepts numeric data for all arguments. Returns numeric data.
BETA.INV(0.75,B3,C3,2,4)
BETA.INV(0.75,R3C2,R3C3,2,4)
BETA.INV(0.75,9,12,2,4) gives the result 3.0011968805340232