How to use BINOM.DIST function in excel

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.

Table of Contents

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 function.

6. Then select ok.

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.

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.