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
trials: The number of tries.probability_s: The chance of success on each try.alpha: The cumulative chance to reach, between 0 and 1.
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
Heads in 6 tosses, covering 75% of outcomes
A B C D E 1 Tosses Chance Target 2 6 0.5 0.75 4 In E2:
=BINOM.INV(A2, B2, C2)→ 4
Common mistakes
- Target of 0 or 1. The target must be strictly between 0 and 1.
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.
- Czech: BINOM.INV
- Danish: BINOMIAL.INV
- Dutch: BINOMIALE.INV
- Finnish: BINOMIJAKAUMA.KÄÄNT
- French: LOI.BINOMIALE.INVERSE
- German: BINOM.INV
- Hungarian: BINOM.INVERZ
- Italian: INV.BINOM
- Norwegian: BINOM.INV
- Polish: ROZKŁ.DWUM.ODWR
- Portuguese (Brazil): INV.BINOM
- Portuguese (Portugal): INV.BINOM
- Russian: БИНОМ.ОБР
- Spanish: INV.BINOM
- Swedish: BINOM.INV
- Turkish: BİNOM.TERS
Also written as CRITBINOM.
Try BINOM.INV in the playground
Related functions
- BINOM.DIST: The chance of a number of successes in a set number of tries, each with the same chance.
- BINOM.DIST.RANGE: The chance that the number of successes in a set of tries lands between two counts.