<< Click to Display Table of Contents >> NEGBINOMDIST (negative binomial distribution)

Note: NEGBINOMDIST is supplemented by the new function NEGBINOM.DIST with additional functionality, which is available in newer versions of Microsoft Excel (2010 or later).

Syntax:

NEGBINOMDIST(k, r, p)

Description:

Returns the negative binomial distribution (also known as Pascal distribution).

The negative binomial distribution can be used to calculate the probability to receive k failures before the r-th success in an experiment with independent trials and only two possible outcomes (success or failure) with a fixed probability of p for each trial.

k is the number of failures. Must be ≥ 0.

r is the number of successes. Must be ≥ 0.

k and r should be integers. If this is not the case, digits right of the decimal point are ignored by PlanMaker.

p is the probability of a success for each trial run. Must be in the range 0 to 1.

Example:

In an urn there are 1 red and 5 black balls. What is the probability (with the balls being returned) to draw exactly 10 black balls (=failures) before the 2nd red ball (=success) is drawn?

NEGBINOMDIST(10, 2, 1/6) returns 0.04935.

See also:

NEGBINOM.DIST, BINOM.DIST.RANGE/BINOM.DIST/BINOMDIST, HYPGEOM.DIST/HYPGEOMDIST