NEGBINOM.DIST
Returns the negative binomial distribution
Syntax
NEGBINOM.DIST(number_f, number_s, probability_s, cumulative)
Parameters
- number_f: Required. The number of failures
- number_s: Required. The threshold number of successes
- probability_s: Required. The probability of a success
- cumulative: Required. TRUE for cumulative, FALSE for probability mass
Example
=NEGBINOM.DIST(10, 5, 0.25, FALSE)