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