Create a binomial distribution and test it in Excel with Python

In my last post I discussed the normal distribution, which can be read here:- https://medium.com/@tracyrenee61/create-a-normal-distribution-and-test-it-with-python-in-excel-80a4942e3f45

In this post i intend to discuss the binomial distribution and how to test it.

The binomial distribution is one of the most popular distributions in statistics. In order to understand the binomial distribution, it is first necessary to understand binomial experiments.

The binomial experiment

A binomial experiment has the following properties:-

1. The experiment consists of n repeated trials.
2. Each trial has only two possible outcomes.
3. The probability of success, p, is the same for each trial.
4. Each trial is independent.

Perhaps the most common example of the binomial experiment where a coin is tossed ten times because:-

1. The experiment consists of ten repeated trials.
2. Eac trial has only two possible outcomes, being heads or tails.
3. The probability of success is the same for each trial, being 0.5 in this instance.
4. Each trial is independent because each coin…