Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.

How To Use in Sheets

NEGBINOMDIST(num_failures, num_successes, prob_success)

External Links

Google Sheets NEGBINOMDIST Negative Binomial Distribution using COMBINA ARRAYFORMULA Data Validation

This video shows the use of COMBINA, ARRAYFORMULA, and Data Validation to generate the data set of NEGBINOMDIST function or Negative Binomial Distribution.

0Better Sheets Tutorials

No videos yet. Stay tuned!