Excel functions / Statistics
NEGBINOMDIST function
The chance of exactly a number of failures before a given number of successes. The older form of NEGBINOM.DIST.
Syntax
=NEGBINOMDIST(number_f, number_s, probability_s)
Arguments
number_f: The number of failures.number_s: The number of successes to reach.probability_s: The chance of success on each try.
When to use it
NEGBINOMDIST is the older form of NEGBINOM.DIST with FALSE.
Examples
Exactly 10 failures
A B C D E 1 Failures Successes Chance 2 10 5 0.25 0.0550 In E2:
=NEGBINOMDIST(A2, B2, C2)→ 0.0550
Common mistakes
- Newer form. NEGBINOM.DIST also gives the cumulative chance.
NEGBINOMDIST 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: NEGBINOMDIST
- Danish: NEGBINOMFORDELING
- Dutch: NEG.BINOM.VERD
- Finnish: BINOMIJAKAUMA.NEG
- French: LOI.BINOMIALE.NEG
- German: NEGBINOMVERT
- Hungarian: NEGBINOM.ELOSZL
- Italian: DISTRIB.BINOM.NEG
- Norwegian: NEGBINOM.FORDELING
- Polish: ROZKŁAD.DWUM.PRZEC
- Portuguese (Brazil): DIST.BIN.NEG
- Portuguese (Portugal): DIST.BIN.NEG
- Russian: ОТРБИНОМРАСП
- Spanish: NEGBINOMDIST
- Swedish: NEGBINOMFÖRD
- Turkish: NEGBİNOMDAĞ
Try NEGBINOMDIST in the playground
Related functions
- NEGBINOM.DIST: The negative binomial distribution: the chance of a number of failures before a given number of successes.