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

When to use it

NEGBINOMDIST is the older form of NEGBINOM.DIST with FALSE.

Examples

  1. Exactly 10 failures

    ABCDE
    1FailuresSuccessesChance
    21050.250.0550

    In E2: =NEGBINOMDIST(A2, B2, C2) → 0.0550

    Try this example

Common mistakes

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.

Translate a whole formula

Try NEGBINOMDIST in the playground

Related functions