81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199

BINOMDIST()

Description

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 featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.