BETAINV function
BETAINV reverses BETADIST: given a probability, it finds the point on the beta curve that reaches it. It is a compatibility function; use BETA.INV in new workbooks.
Example
Read it as a sentence: find the value at which the cumulative beta probability reaches 0.5, with alpha 2 and beta 2, which gives 0.5.
A
B
C
D
1
0.5
2
3
Syntax
BETAINV(probability, alpha, beta, [A], [B])
Arguments in [square brackets] are optional.
-
probability(required) - Cumulative probability, strictly between 0 and 1.
-
alpha(required) - First shape parameter.
-
beta(required) - Second shape parameter.
-
A(optional) - Lower bound; default 0.
-
B(optional) - Upper bound; default 1.
Returns: The x value whose cumulative beta probability equals the given probability.
What Excel actually returns
Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.
| Formula | Excel shows | Case |
|---|---|---|
=BETAINV(0.5,2,2) | 0.5 | Working example |
=BETAINV("0.5",2,2) | 0.5 | Text-number in first arg |
=BETAINV({0.5,0.5},2,2) | 0.5 | Array in first arg (lifts, spills) |
=BETAINV(0.5,2,2,1,5) | 3 | With bounds |
=BETAINV("abc",2,2) | #VALUE! | Non-numeric text in first arg |
=BETAINV(NA(),2,2) | #N/A | Error in first arg |
=BETAINV(0,2,2) | #NUM! | Probability 0 |
=BETAINV(1.5,2,2) | #NUM! | Probability above 1 |
Watch out for
- Superseded by BETA.INV; use that in new workbooks.
- Solved iteratively, so a hard case can return #N/A.
Where it works
- Excel
- BETAINV is in every version of Excel from 2007 on. Compatibility function: still works in every version, but newer replacements exist.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Compatibility functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .