BETA.DIST function
BETA.DIST evaluates the beta distribution, which models quantities that live between two limits, such as a completion percentage or a proportion. It is used in project-risk modeling and Bayesian work.
Example
Read it as a sentence: find the cumulative beta probability at 0.5 with alpha 2 and beta 3, which gives 0.6875.
A
B
C
D
1
0.6875
2
3
Syntax
BETA.DIST(x, alpha, beta, cumulative, [A], [B])
Arguments in [square brackets] are optional.
-
x(required) - Value between A and B at which to evaluate.
-
alpha(required) - First shape parameter, above 0.
-
beta(required) - Second shape parameter, above 0.
-
cumulative(required) - TRUE for the cumulative distribution, FALSE for the density.
-
A(optional) - Lower bound of x; default 0.
-
B(optional) - Upper bound of x; default 1.
Returns: The beta distribution probability (cumulative) or density at 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 |
|---|---|---|
=BETA.DIST(0.5,2,3,TRUE) | 0.6875 | Working example |
=BETA.DIST(0.5,2,3,FALSE) | 1.5 | Other cumulative flag |
=BETA.DIST(0.5,2,3,0) | 1.5 | Cumulative as 0 |
=BETA.DIST("0.5",2,3,TRUE) | 0.6875 | Text-number in first arg |
=BETA.DIST({0.5,0.5},2,3,TRUE) | 0.6875 | Array in first arg (lifts, spills) |
=BETA.DIST(3,2,3,TRUE,1,5) | 0.6875 | With bounds A,B |
=BETA.DIST("abc",2,3,TRUE) | #VALUE! | Non-numeric text in first arg |
=BETA.DIST(NA(),2,3,TRUE) | #N/A | Error in first arg |
Watch out for
- x must lie between A and B or you get #NUM!.
- Replaces the older BETADIST, which had no cumulative switch.
Where it works
- Excel
- BETA.DIST 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 .