NEGBINOM.DIST
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
NEGBINOM.DIST(
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 number_f failures before the required number of successes.
- cumulative: The probability type. FALSE = probability mass function; TRUE = cumulative distribution.