Excel functions / Statistics
BINOM.DIST function
The chance of a number of successes in a set number of tries, each with the same chance.
Syntax
=BINOM.DIST(number_s, trials, probability_s, cumulative)
Arguments
number_s: How many successes.trials: How many tries.probability_s: The chance of success on each try.cumulative: TRUE for that many or fewer; FALSE for exactly that many.
When to use it
BINOM.DIST gives the chance of a number of successes in a set of tries, when each try has the same chance of success: heads in coin tosses, defective items in a batch, people who say yes. With FALSE it is the chance of exactly that many; with TRUE, that many or fewer.
Examples
Exactly 6 heads in 10 tosses
A B C D 1 Heads Tosses 2 6 10 20.5% In D2:
=BINOM.DIST(A2, B2, 0.5, FALSE)→ 20.5%At most 2 faulty items in 50, when 2% are faulty
A B C D 1 Faulty Batch 2 2 50 92.2% In D2:
=BINOM.DIST(A2, B2, 2%, TRUE)→ 92.2%
Common mistakes
- TRUE or FALSE. FALSE is exactly that many; TRUE is that many or fewer. For "at least", use 1 minus the TRUE result for one fewer.
BINOM.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.
- Czech: BINOM.DIST
- Danish: BINOMIAL.FORDELING
- Dutch: BINOM.VERD
- Finnish: BINOMI.JAKAUMA
- French: LOI.BINOMIALE.N
- German: BINOM.VERT
- Hungarian: BINOM.ELOSZL
- Italian: DISTRIB.BINOM.N
- Norwegian: BINOM.FORDELING.N
- Polish: ROZKŁ.DWUM
- Portuguese (Brazil): DISTR.BINOM
- Portuguese (Portugal): DISTR.BINOM
- Russian: БИНОМ.РАСП
- Spanish: DISTR.BINOM.N
- Swedish: BINOM.FÖRD
- Turkish: BİNOM.DAĞ
Also written as BINOMDIST.
Try BINOM.DIST in the playground
Related functions
- BINOM.INV: The smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.
- BINOM.DIST.RANGE: The chance that the number of successes in a set of tries lands between two counts.
- POISSON.DIST: The chance of a number of events in a period, given how many happen on average.
- COMBIN: How many ways to choose a number of items from a group, when the order does not matter.