NEGBINOM.DIST function

NEGBINOM.DIST(FailureCount, SuccessThreshold, Probability, IsCumulative) NEGBINOM.DIST(FailureCount; SuccessThreshold; Probability; IsCumulative)

FailureCount

Number or { Number }

The number of failures in a set of trials.

SuccessThreshold

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.