BETA.INV function
BETA.INV works backwards from a probability to the x value for a beta distribution. It is the inverse of BETA.DIST with its cumulative option set to TRUE.
Example
Read it as a sentence: find the value at which the cumulative beta probability reaches 0.6875, with alpha 2 and beta 3, which gives 0.5.
A
B
C
D
1
0.5
2
3
Syntax
BETA.INV(probability, alpha, beta, [A], [B])
Arguments in [square brackets] are optional.
-
probability(required) - Cumulative probability 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 beta cumulative 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 |
|---|---|---|
=BETA.INV(0.6875,2,3) | 0.5 | Working example |
=BETA.INV("0.6875",2,3) | 0.5 | Text-number in first arg |
=BETA.INV({0.6875,0.6875},2,3) | 0.5 | Array in first arg (lifts, spills) |
=BETA.INV(0.5,2,3,1,5) | 2.542910273 | With bounds |
=BETA.INV("abc",2,3) | #VALUE! | Non-numeric text in first arg |
=BETA.INV(NA(),2,3) | #N/A | Error in first arg |
=BETA.INV(0,2,3) | #NUM! | Probability 0 |
=BETA.INV(1,2,3) | #NUM! | Probability 1 |
Watch out for
- Calculated by iteration, so extreme inputs may return #N/A.
- Probability must be greater than 0 and at most 1.
Where it works
- Excel
- BETA.INV arrived in Excel 2010. Older versions do not have it.
- Google Sheets
- Same name, same behaviour for everyday use.
Part of Statistical functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .