NEGBINOM.DIST function

NEGBINOM.DIST(numberOfFailures, successesThreshold, probability, isCumulative) NEGBINOM.DIST(numberOfFailures; successesThreshold; probability; isCumulative)

numberOfFailures

Number or { Number }

The number of failures in a set of trials.

successesThreshold

Number or { Number }

The threshold number of successes.

probability

Number or { Number }

The probability of success in each trial.

isCumulative

Logical or { Logical }

FALSE to calculate the probability density function and TRUE to calculate the cumulative distribution function.

Returns

Number or { Number }

A probability for a negative binomial distribution.

Returns a probability for a negative binomial distribution.

Example

NEGBINOM.DIST(1, 1, 0.5, FALSE)NEGBINOM.DIST(1; 1; 0,5; FALSE)

Returns 0.25 (25%), the probability that heads will come up exactly once before tails has come up when tossing a coin.

Partly derived from the OpenOffice.org documentation, licensed under the Apache License 2.0.