What is BINOM.DIST.RANGE function in Excel?
The BINOM.DIST.RANGE function is one of the Statistical functions of Excel.
It Returns the probability of a trial result using a binomial distribution.
We can find this function in Statistical category of insert function Tab.
How to use BINOM.DIST.RANGE function in excel
- Click on an empty cell (like F5).
2. Click on the fx icon (or press shift+F3).
3. In the insert function tab you will see all functions.
4. Select STATISTICAL category.
5. Select BINOM.DIST.RANGE function.
6. Then select ok.
7. In the function arguments Tab you will see BINOM.DIST.RANGE function.
8. Trials are the number of independent trials.
9. Probability _s is the probability of success on each trial.
10. Number s is the number of successes in trials.
11. Number s2 if provided this function returns the probability that the number of successful trials shall lie between number s and number s2.
12. You will see the results in the formula result section.
Examples of BINOM.DIST.RANGE function in Excel
BINOM.DIST.RANGE related functions
- Use BINOM.DIST function to return the individual term binomial distribution probability.
- Use BINOM.INV function to return the smallest value for which the cumulative binomial distribution is greater than or equal to a criterion value.
