NEGBINOMDIST (negative binomial distribution)

<< 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:

This returns the negative binomial distribution (also known as Pascal distribution).

The negative binomial distribution can be used to calculate the probability of obtaining k failures before the r-th success in a random 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. It must be ≥ 0.

r is the number of successes. It must be ≥ 0.

k and r should be integers. If this is not the case, PlanMaker automatically truncates the decimal places.

p is the probability of success for each trial run. It must be within the range 0 to 1.

Example:

An urn contains 1 red ball and 5 black balls. What is the probability (with the balls being returned) of drawing 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