Binomial distribution

Excel has got many features connected with statistics. For examples Excel could help you to calculate binomial distribution. Let's teach yourself how to do it in this easy steps.

1. Enter data in Excel sheet and form three columns, one indicating no. of successes, probability of success and trials.

data table

2. It is calculated by using the BINOM.DIST formula:

BINIM.DIST formula

 

0 in the end of the formula indicates that the required probability is exactly or less than or equal to two.

1 in the end of the formula indicates that the required proability is more than or (at most) 2.

probability