Excel functions / Statistics
BINOM.DIST.RANGE function
The chance that the number of successes in a set of tries lands between two counts.
Syntax
=BINOM.DIST.RANGE(trials, probability_s, number_s, [number_s2])
Arguments
trials: The number of tries.probability_s: The chance of success on each try.number_s: The lowest number of successes.number_s2(optional): The highest number of successes. Left out, the result is the chance of exactly number_s.
When to use it
BINOM.DIST.RANGE gives the chance that the number of successes in a set of tries lands between two counts.
Examples
45 to 50 successes in 60 tries at 75%
A B C D 1 Tries Chance 2 60 0.75 0.524 In D2:
=BINOM.DIST.RANGE(A2, B2, 45, 50)→ 0.524
Common mistakes
- One count. Leave out the last argument for the chance of exactly one count.
BINOM.DIST.RANGE 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.RANGE
- Danish: BINOMIAL.DIST.INTERVAL
- Dutch: BINOM.VERD.BEREIK
- Finnish: BINOMI.JAKAUMA.ALUE
- French: LOI.BINOMIALE.SERIE
- German: BINOM.VERT.BEREICH
- Hungarian: BINOM.ELOSZL.TART
- Italian: INTERVALLO.DISTRIB.BINOM.N.
- Norwegian: BINOM.FORDELING.OMRÅDE
- Polish: ROZKŁ.DWUM.ZAKRES
- Portuguese (Brazil): INTERV.DISTR.BINOM
- Portuguese (Portugal): DIST.BINOM.INTERVALO
- Russian: БИНОМ.РАСП.ДИАП
- Spanish: DISTR.BINOM.SERIE
- Swedish: BINOM.FÖRD.INTERVALL
- Turkish: BİNOM.DAĞ.ARALIK
Try BINOM.DIST.RANGE 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.INV: The smallest number of successes whose cumulative binomial chance reaches a target: how many to plan for.