Calculates the probability of drawing a certain number of failures before a certain number of successes given a probability of success in independent trials.
Description
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!