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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| x | Yes | The value, between A and B. |
| alpha | Yes | Shape parameter; must be greater than 0. |
| beta | Yes | Shape parameter; must be greater than 0. |
| cumulative | Yes | TRUE for the cumulative probability, FALSE for the density (height of the curve). |
| A | No | Lower bound (0 if left out). |
| B | No | Upper 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).
| A | B | |
|---|---|---|
| 1 | Measure | Value |
| 2 | alpha | 2 |
| 3 | beta | 3 |
| 4 | Shortest (A) | 4 |
| 5 | Longest (B) | 10 |
| 6 | Done within 7 days | 0.6875 |
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.
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
- BETA.DIST replaces the older BETADIST function.
- Related functions: BETA.INV, BINOM.DIST.

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.