BETADIST function
BETADIST gives the cumulative probability of a beta distribution, used for proportions and completion-style models bounded between two limits. It is a compatibility function; use BETA.DIST in new workbooks.
Example
Read it as a sentence: find the cumulative beta probability at the value in D1 (empty, so 0), with alpha 2 and beta 2.
Excel shows 0
D
1
Data
Syntax
BETADIST(x, alpha, beta, [A], [B])
Arguments in [square brackets] are optional.
-
x(required) - Value between A and B at which to evaluate the cumulative distribution.
-
alpha(required) - First shape parameter, must be above 0.
-
beta(required) - Second shape parameter, must be above 0.
-
A(optional) - Lower bound of the interval; default 0.
-
B(optional) - Upper bound of the interval; default 1.
Returns: Cumulative beta probability up to x.
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 |
|---|---|---|
=BETADIST(0.25,2,2) | 0.15625 | Working example |
=BETADIST("0.25",2,2) | 0.15625 | Text-number in first arg |
=BETADIST({0.25,0.25},2,2) | 0.15625 | Array in first arg (lifts, spills) |
=BETADIST(3,2,2,1,5) | 0.5 | With bounds |
=BETADIST(Data!D1,2,2) | 0 | Blank cell as first arg |
=BETADIST("abc",2,2) | #VALUE! | Non-numeric text in first arg |
=BETADIST(NA(),2,2) | #N/A | Error in first arg |
=BETADIST(2,2,2) | #NUM! | X above 1 |
The Data sheet these formulas read
A cell that starts with = holds that formula.
D
1
Data
Watch out for
- Superseded by BETA.DIST; use that in new workbooks.
- Only the cumulative form exists; BETA.DIST lets you ask for the density too.
- x outside A..B returns #NUM!.
Where it works
- Excel
- BETADIST 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 .