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

  1. Click on an empty cell (like F5).
 an empty cell in excel

2. Click on the fx icon (or press shift+F3).

fx icon in excel

3. In the insert function tab you will see all functions.

function list in excel

4. Select STATISTICAL category.

5. Select BINOM.DIST.RANGE function.

6. Then select ok.

excel BINOM.DIST.RANGE function

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.

Leave a Reply

Your email address will not be published. Required fields are marked *