NEGBINOM.DIST

Try it

When to use it

When should I use NEGBINOM.DIST?

Use NEGBINOM.DIST to model the number of failures before a fixed number of successes — for example, the probability of encountering 4 defective items before finding 2 acceptable ones in quality control, or the number of customer rejections before closing a given number of sales.

Used in

operations · science

Syntax

NEGBINOM.DIST(x,r,p,cumulative)

Examples

=NEGBINOM.DIST(4,2,0.1,TRUE) // => 0.11426499999999984
=NEGBINOM.DIST(4,2,0.1,FALSE) // => 0.032805
=NEGBINOM.DIST(0,1,0.5,FALSE) // => 0.5