Excel functions / Statistics

GAMMA.INV function

The value below which a given share of a gamma distribution falls.

Syntax

=GAMMA.INV(probability, alpha, beta)

Arguments

When to use it

GAMMA.INV gives the value below which a share of a gamma distribution falls.

Examples

  1. Undo GAMMA.DIST

    ABCDE
    1palphabeta
    20.0680949210.0000

    In E2: =GAMMA.INV(A2, B2, C2) → 10.0000

    Try this example

Common mistakes

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

Try GAMMA.INV in the playground

Related functions