NEGBINOM.DIST()/NEGBINOMDIST()

Syntax. NEGBINOM.DIST(number_f,number_s,probability_s)

Definition. This function returns the probabilities of a negative binomial distributed random variable. NEGBINOM.DIST() calculates the probability that there will be number_f failures before the last number_s when the constant probability of a success is probability_s.

Arguments

  • number_f (required). The number of failures

  • number_s (required). The number of successes

  • probability_s (required). The probability of a success

Note

Number_f and number_s are truncated to integers. If one of the arguments isn’t a numeric expression, the NEGBINOM.DIST() function returns the #VALUE! error.

If probability_s is less than 0 or greater than 1, the NEGBINOM.DIST() function returns the ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial