Excel functions / Statistics
BETADIST function
The chance of x or less in a beta distribution. The older form of BETA.DIST.
Syntax
=BETADIST(x, alpha, beta, [A], [B])
Arguments
x: The value, between the bounds A and B.alpha: The first shape parameter.beta: The second shape parameter.A(optional): The lower bound. Left out, it is 0.B(optional): The upper bound. Left out, it is 1.
When to use it
BETADIST is the older form of BETA.DIST with TRUE: the chance of a value of x or less.
Examples
Below 2, between 1 and 3
A B C D E 1 x alpha beta 2 2 8 10 0.6855 In E2:
=BETADIST(A2, B2, C2, 1, 3)→ 0.6855
Common mistakes
- Newer form. BETA.DIST also gives the height of the curve.
BETADIST 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: BETADIST
- Danish: BETAFORDELING
- Dutch: BETAVERD
- Finnish: BEETAJAKAUMA
- French: LOI.BETA
- German: BETAVERT
- Hungarian: BÉTA.ELOSZLÁS
- Italian: DISTRIB.BETA
- Norwegian: BETA.FORDELING
- Polish: ROZKŁAD.BETA
- Portuguese (Brazil): DISTBETA
- Portuguese (Portugal): DISTBETA
- Russian: БЕТАРАСП
- Spanish: DISTR.BETA
- Swedish: BETAFÖRD
- Turkish: BETADAĞ
Try BETADIST in the playground