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.