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

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

  1. Below 2, between 1 and 3, alpha 8 and beta 10

    ABCDE
    1xalphabeta
    228100.6855

    In E2: =BETA.DIST(A2, B2, C2, TRUE, 1, 3) → 0.6855

    Try this example

Common mistakes

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.

Translate a whole formula

Try BETA.DIST in the playground

Related functions