BETA.INV (Probability, Alpha, Beta, A?, B?) BETA.INV (Probability; Alpha; Beta; A?; B?)
Probability
Number Number
The probability associated with the distribution.
Alpha
Number Number
A parameter controlling the shape of the distribution.
Beta
Number Number
A parameter controlling the shape of the distribution.
A
Number Number (optional)
A lower bound for the result. If omitted, the lower bound is assumed to be 0.
B
Number Number (optional)
An upper bound for the result. If omitted, the upper bound is assumed to be 1.
Returns the inverse of the cumulative BETA.DIST function. Given a probability, this function returns the value at which the cumulative beta distribution equals that probability.
Example
BETA.INV (0.96, 3, 4)
BETA.INV (0,96; 3; 4)
Returns roughly 0.75.