Skip to Content

NEGBINOMDIST

Returns the negative binomial distribution. Replaced by NEGBINOM.DIST.

Syntax

NEGBINOMDIST(number_f, number_s, probability_s)

Parameters

  • number_f: Required. The number of failures
  • number_s: Required. The threshold number of successes
  • probability_s: Required. The probability of a success

Example

=NEGBINOMDIST(10, 5, 0.25)
Returns: NumberSince: Excel 2003