Excel functions / Statistics

GAMMA.DIST function

The gamma distribution, for values that cannot be negative and lean to the right, such as waiting times.

Syntax

=GAMMA.DIST(x, alpha, beta, cumulative)

Arguments

When to use it

GAMMA.DIST works with the gamma distribution, for values that cannot be negative and lean to the right, such as waiting times and claim sizes.

Examples

  1. Below 10 with alpha 9 and beta 2

    ABCDE
    1xalphabeta
    210.00001131920.0681

    In E2: =GAMMA.DIST(A2, B2, C2, TRUE) → 0.0681

    Try this example

Common mistakes

GAMMA.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

Also written as GAMMADIST.

Try GAMMA.DIST in the playground

Related functions