Excel functions / Statistics

BINOM.INV function

The smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.

Syntax

=BINOM.INV(trials, probability_s, alpha)

Arguments

When to use it

BINOM.INV gives the smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for so that a share of outcomes is covered.

Examples

  1. Heads in 6 tosses, covering 75% of outcomes

    ABCDE
    1TossesChanceTarget
    260.50.754

    In E2: =BINOM.INV(A2, B2, C2) → 4

    Try this example

Common mistakes

BINOM.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 CRITBINOM.

Try BINOM.INV in the playground

Related functions