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

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

  1. Exactly 10 failures before 5 successes at 25%

    ABCDE
    1FailuresSuccessesChance
    21050.250.0550

    In E2: =NEGBINOM.DIST(A2, B2, C2, FALSE) → 0.0550

    Try this example

Common mistakes

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.

Translate a whole formula

Try NEGBINOM.DIST in the playground

Related functions