Excel BINOM.DIST function
The BINOM.DIST function returns the individual term binominal distribution probability, which can be used to calculate the probability of a specified number of successes out of a given number of trials.
Syntax
BINOM.DIST(number_s, trials, probability_s, cumulative)
Arguments
- Number_s (required): The number of successes in trials;
- Trials (required): The number of independent trials;
- Probability_s (required): The probability of success per trial;
- Cumulative (required): A logical value used to determine the form of the function. It can be:
Remarks
Return value
It returns a numeric value.
Example
As shown in the table below, there are 6 successes in 14 trials, and the probability of success in each trial is 0.5. To calculate the probability of at most 6 successes out of 14 trials and the probability of 6 successes out of 14 trials separately, you can apply the BINOM.DIST function as follows.
1. Calculate the probability of exactly 6 successes out of 14 trials.
Select a cell (E6 in this case), copy or enter the formula below and press Enter to get the result.
=BINOM.DIST(B6,C6,D6,FALSE)
2. Calculate the probability of at most 6 successes out of 14 trials.
Select a cell (E7 in this case), copy or enter the formula below and press Enter to get the result.
=BINOM.DIST(B7,C7,D7,TRUE)
Related Functions
Excel BINOMDIST function
The BINOMDIST function returns the individual term binominal distribution probability.
The Best Office Productivity Tools
Kutools for Excel - Helps You To Stand Out From Crowd
Kutools for Excel Boasts Over 300 Features, Ensuring That What You Need is Just A Click Away...
Office Tab - Enable Tabbed Reading and Editing in Microsoft Office (include Excel)
- One second to switch between dozens of open documents!
- Reduce hundreds of mouse clicks for you every day, say goodbye to mouse hand.
- Increases your productivity by 50% when viewing and editing multiple documents.
- Brings Efficient Tabs to Office (include Excel), Just Like Chrome, Edge and Firefox.