BETA.INVn
Returns the inverse of the cumulative distribution function for a specified beta distribution.
StatisticalStatistics & Analysis
What it does
Returns the inverse of the cumulative beta probability density function.
Syntax
BETA.INV(probability, alpha, beta, [A], [B])
Arguments
probability(number) — A probability between 0 and 1.alpha(number) — Parameter of the distribution.beta(number) — Parameter of the distribution.
Examples
Inverse Beta
Calculate inverse beta for 68.5% probability.
FORMULA
=BETA.INV(0.6855, 8, 10)
RESULT
0.5
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Prob | Alpha | Beta |
| 2 | 0.6855 | 8 | 10 |