Formualizer Docs

NEGBINOMDIST

Returns the negative binomial probability of number_f failures (legacy name).

NEGBINOMDIST(number_f, number_s, probability_s) is the probability mass form of NEGBINOM.DIST: the chance of exactly number_f failures before the number_s-th success.

The Formualizer engine in this repository at 0.14.0 plus unreleased changes computes the example results. Known differences from Excel are listed on this page.

Syntax

=NEGBINOMDIST(number_f, number_s, probability_s)

Arguments

ArgumentTypeRequiredDefault
number_fnumberRequired—
number_snumberRequired—
probability_snumberRequired—

How it works

Maps to NEGBINOM.DIST with cumulative set to FALSE. The result at f failures before the rth success is the binomial coefficient C(f+r−1,f) times pʳ(1−p)ᶠ. Counts require f ≥ 0 and r ≥ 1, with probability in [0,1].

Remarks

  • number_f and number_s are truncated to integers.

Error cases

  • Returns #NUM! when probability_s < 0, probability_s > 1, number_f < 0, or number_s < 1.

Examples

Find the probability for three failures before the fourth success.

Formula =NEGBINOMDIST(3,4,0.5)

Expected result 0.15625

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Compare the chance of five failures at a lower per-trial success probability.

Formula =NEGBINOMDIST(5,4,0.45)

Expected result 0.115571707453125

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Evaluate the probability of four successes without any failure.

Formula =NEGBINOMDIST(0,4,0.5)

Expected result 0.0625

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

The failure count cannot be negative.

Formula =NEGBINOMDIST(-1,4,0.5)

Expected result #NUM!

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Find the chance of ten failures before the fifth success at a 25% per-trial success rate.

Formula =NEGBINOMDIST(10,5,0.25)

Expected result 0.0550486603751779

Try this formula

This editor runs the published Formualizer 0.14.0 package, so the last digits can differ and functions newer than that release return #NAME?.

Implementation

Engine source

On this page