Excel functions / Statistics

BETA.INV function

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

Syntax

=BETA.INV(probability, alpha, beta, [A], [B])

Arguments

When to use it

BETA.INV gives the value below which a share of a beta distribution falls.

Examples

  1. Undo BETA.DIST

    ABCDE
    1palphabeta
    20.6854705818102.000

    In E2: =BETA.INV(A2, B2, C2, 1, 3) → 2.000

    Try this example

Common mistakes

BETA.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 BETAINV.

Try BETA.INV in the playground

Related functions