NEGBINOMDIST
Description
Returns the negative binomial distribution. Similar to BINOMDIST() and BINOM.DIST() but in NEGBINOM.DIST() the number of trials is variable and the number of successes is fixed.
Syntax
NEGBINOMDIST(
number_f
,
number_s
,
probability_s
, [
cumulative
])
- number_f: The number of failures.
- number_s: The required number of successes.
- probability_s: The probability of success.
- cumulative: The type of distribution to use. FALSE = probability mass function; TRUE = cumulative distribution function.