Practice free

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.

Practice this in the app

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.

FormulaExcel showsCase
=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 .