Excel BINOM.DIST Function

What is BINOM.DIST function in Excel?

The BINOM.DIST function is one of the Statistical functions of Excel.

It Returns the individual term binomial distribution probability.

We can find this function in Statistical categoryof insert function Tab.

How to use BINOM.DIST 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 function.

6. Then select ok.

excel BINOM.DIST function

7. In the function arguments Tab you will see BINOM.DIST function.

8. Numbers are the number of successes in trials.

9. Trials are the number of independent trials.

10. Probability _s is the probability of success on each trial.

11. Cumulative is a logical value: for the cumulative distribution function, use TRUE; for the probability mass function, use FALSE.

12. You will see the results in the formula result section.

Examples of BINOM.DIST function in Excel

BINOM.DIST related functions 

  • Use BINOM.DIST.RANGE function to return the probability of a trial result using a binomial distribution.
  • 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 *