Problem 2. Simulate a coin toss. Let X = 1 indicate heads and X = 0 indicate tails. The probability of heads is .7. One trial of an experiment consists of n = 10 tosses. For each trial,

ni=1 X_i is the total number of heads in 10 tosses. Run the experiment with 1,000 trials and

ni=1 X_i, plot a histogram for nX_i. (A DataTable may make sense here.)

Tocreate histogram in Excel, use the Data Analysis Add-In.Once the Add-In is installed, go to DATA Data Analysis Histogram. Enter in the input data information in the input range and hit OK. A new worksheet will appear. Then, without click anything first and with the histogram information still highlighted, go to INSERT Insert Column Chart and choose the first 2-D column. A bar chart should appear. Toformat it to look like a histogram, with zero gap between the bins, right click on a bar and choose FormatData Series. Make theSeries Overlap and Gap Width both 0%. You will also want to add a line to the border of the bars (peruse the various SERIES OPTIONS).