Formulas > =BINOM.DIST()
How to Use BINOM.DIST() in Google Sheets
Description
How To Actually Use BINOM.DIST() in Sheets
BINOM.DIST(num_successes, num_trials, prob_success, cumulative)
Try BINOM.DIST yourself
Use the BINOM.DIST formula to calculate the probability of getting exactly 3 successes in 10 trials with a success probability of 0.5. Place your formula in cell D1.
Hints (2)
-
Remember to set the cumulative parameter to FALSE for exact probabilities.
-
Identify the number of successes, trials, and success probability from the problem statement.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the BINOM.DIST() formula:
Generate a BINOM.DIST() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses BINOM.DIST(). 2 free AI generations, no signup. Members get unlimited use.
Generate a BINOM.DIST() formula