Excel functions / Statistics
NEGBINOM.DIST function
The negative binomial distribution: the chance of a number of failures before a given number of successes.
Syntax
=NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
Arguments
number_f: The number of failures.number_s: The number of successes to reach.probability_s: The chance of success on each try.cumulative: TRUE for the chance of number_f failures or fewer; FALSE for exactly number_f.
When to use it
NEGBINOM.DIST gives the chance of a number of failures before a given number of successes: how many calls before five sales.
Examples
Exactly 10 failures before 5 successes at 25%
A B C D E 1 Failures Successes Chance 2 10 5 0.25 0.0550 In E2:
=NEGBINOM.DIST(A2, B2, C2, FALSE)→ 0.0550
Common mistakes
- Counting tries. It counts failures, not total tries: add the successes for the number of tries.
NEGBINOM.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: NEGBINOM.DIST
- Danish: NEGBINOM.FORDELING
- Dutch: NEGBINOM.VERD
- Finnish: BINOMI.JAKAUMA.NEG
- French: LOI.BINOMIALE.NEG.N
- German: NEGBINOM.VERT
- Hungarian: NEGBINOM.ELOSZLÁS
- Italian: DISTRIB.BINOM.NEG.N
- Norwegian: NEGBINOM.FORDELING.N
- Polish: ROZKŁ.DWUM.PRZEC
- Portuguese (Brazil): DIST.BIN.NEG.N
- Portuguese (Portugal): DIST.BINOM.NEG
- Russian: ОТРБИНОМ.РАСП
- Spanish: NEGBINOM.DIST
- Swedish: NEGBINOM.FÖRD
- Turkish: NEGBİNOM.DAĞ
Try NEGBINOM.DIST 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.
- NEGBINOMDIST: The chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.