For this excel workbook I would like you to create a histogram of the number of heads you get if you toss a coin multiple times.

The user should be able to enter the following information.

Probability of getting a head $($be able to make it not a fair coin$)$

Number of coins tossed $(1-20)$

Number of trials to plot $(1-10,000)$

You should include the following.

Dynamic chart headings

Data validation on all user inputs $($with instructions so the user knows what they should put in$)$

Reasonable errors warning users if they try to enter bad data

The histogram should have no gap width, and should have the frequency of observations on the Y axis

Formatting should be reasonable. It should not just be formulas in a black and white plain workbook.

In addition to the workbook I would like you to include a cumulative distribution of the number of heads on the coins tossed. A CDF looks a lot like the histogram, but instead of each bar showing the frequency of being equal to that value, it shows the probability of being less than or equal to that value. It will always get to $1(100\%)$ at the right hand side of the graph.

Show all work and results in excel.