Excel functions / Statistics
BETA.DIST function
The beta distribution, for shares and percentages that vary between two bounds.
Syntax
=BETA.DIST(x, alpha, beta, cumulative, [A], [B])
Arguments
x: The value, between the bounds A and B.alpha: The first shape parameter.beta: The second shape parameter.cumulative: TRUE for the chance of x or less; FALSE for the height of the curve at x.A(optional): The lower bound. Left out, it is 0.B(optional): The upper bound. Left out, it is 1.
When to use it
BETA.DIST works with the beta distribution, for shares and percentages that vary between two bounds, such as a completion rate or the share of time a task takes.
Examples
Below 2, between 1 and 3, alpha 8 and beta 10
A B C D E 1 x alpha beta 2 2 8 10 0.6855 In E2:
=BETA.DIST(A2, B2, C2, TRUE, 1, 3)→ 0.6855
Common mistakes
- Outside the bounds. x must lie between A and B (0 and 1 if left out).
BETA.DIST in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: BETA.DIST
- Danish: BETA.FORDELING
- Dutch: BETA.VERD
- Finnish: BEETA.JAKAUMA
- French: LOI.BETA.N
- German: BETA.VERT
- Hungarian: BÉTA.ELOSZL
- Italian: DISTRIB.BETA.N
- Norwegian: BETA.FORDELING.N
- Polish: ROZKŁ.BETA
- Portuguese (Brazil): DIST.BETA
- Portuguese (Portugal): DIST.BETA
- Russian: БЕТА.РАСП
- Spanish: DISTR.BETA.N
- Swedish: BETA.FÖRD
- Turkish: BETA.DAĞ
Try BETA.DIST in the playground