BETAINV
Returns the inverse of the cumulative distribution function for a specified beta distribution.
CompatibilityCompatibility / LegacyLegacy / Older Versions
What it does
Older version of BETA.INV. Returns the inverse of the cumulative beta probability density function.
Syntax
BETAINV(probability, alpha, beta, [A], [B])
Arguments
probability(number) — Probability associated with the beta distribution.alpha(number) — Alpha parameter.beta(number) — Beta parameter.
Examples
Legacy Inverse Beta
Calculate using legacy function.
FORMULA
=BETAINV(0.6855, 8, 10)
RESULT
0.5
SAMPLE DATA
| A | B | C | |
|---|---|---|---|
| 1 | Prob | Alpha | Beta |
| 2 | 0.6855 | 8 | 10 |