BETA.DIST Function

Returns the beta distribution — for proportions and values between two limits.

Category

Statistical

Available in

Excel 2010+, Microsoft 365

Returns

A number

Want to practice BETA.DIST in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

The beta distribution describes a value that must lie between two limits — by default 0 and 1, so it suits proportions such as conversion rates — or between your own lower (A) and upper (B) bounds, which makes it popular for project task estimates.

alpha and beta set the shape: alpha = beta is symmetrical; alpha < beta leans toward the lower bound.

TRUE returns the cumulative probability (the chance of a value up to x); FALSE returns the probability density — the height of the curve, not a probability.

Syntax

=BETA.DIST(x, alpha, beta, cumulative, [A], [B])

Arguments

ArgumentRequired?What it does
xYesThe value, between A and B.
alphaYesShape parameter; must be greater than 0.
betaYesShape parameter; must be greater than 0.
cumulativeYesTRUE for the cumulative probability, FALSE for the density (height of the curve).
ANoLower bound (0 if left out).
BNoUpper bound (1 if left out).

Examples

Example 1 — Will the task be done within 7 days?

A task takes between 4 and 10 days, most likely nearer the short end (alpha 2, beta 3).

B6fx=BETA.DIST(7,B2,B3,TRUE,B4,B5)
AB
1MeasureValue
2alpha2
3beta3
4Shortest (A)4
5Longest (B)10
6Done within 7 days0.6875
=BETA.DIST(7,B2,B3,TRUE,B4,B5) Explain

About a 69% chance of finishing within 7 days.

Example 2 — A proportion between 0 and 1

Without A and B, x is a proportion.

=BETA.DIST(0.4,2,3,TRUE) Explain

Returns 0.5248.

Common mistakes

  • #NUM! x is below A or above B, A equals B, or alpha or beta is 0 or negative.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.