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
| Argument | Type | Required | Default |
|---|---|---|---|
number_f | number | Required | — |
number_s | number | Required | — |
probability_s | number | Required | — |
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_fandnumber_sare truncated to integers.
Error cases
- Returns
#NUM!whenprobability_s < 0,probability_s > 1,number_f < 0, ornumber_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?.