Calculates the probability of drawing a certain number of successes (or a maximum number of successes) in a certain number of tries given a population of a certain size containing a certain number of successes, with replacement of draws.

How To Use in Sheets

BINOMDIST(num_successes, num_trials, prob_success, cumulative)

External Links

Google Sheets BINOMDIST Binomial Distribution using COMBIN ARRAYFORMULA Data Validation

This video shows the use of ARRAYFORMULA, Data Validation, and COMBIN function to generate the data sets of BINOMDIST in Binomial Probability Mass Function and Binomial Cumulative Distribution Function.

0Better Sheets Tutorials

No videos yet. Stay tuned!