<< Click to Display Table of Contents >> NEGBINOM.DIST (negative binomial distribution)

Syntax:

NEGBINOM.DIST(k, r, p, Cumulative)

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.

Cumulative determines the type of function as a switch: If you enter the value TRUE, the cumulative distribution function of the negative binomial distribution is calculated. By entering the value FALSE, the probability mass function of the negative binomial distribution is calculated.

Example:

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

NEGBINOM.DIST(10, 2, 1/6, FALSE) returns 0.04935

NEGBINOM.DIST(10, 2, 1/6, TRUE) returns 0.61867

The probability of having to draw exactly 10 black balls is 4.9% (probability mass function). The probability of having to draw at most 10 black balls is 61.9% (cumulative distribution function).

Note:

The NEGBINOM.DIST function supplements the previous NEGBINOMDIST function with the additional argument Cumulative.

Compatibility notes:

Microsoft Excel supports this function only in version 2010 or later. In older versions, the function is unknown.

See also:

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