1) Generate random numbers with 1000 row times 30 variables, but this time use random variables withbinomial distribution of p=0.5, n=1. Let us call it X and X-bar. Create the similar statistics and generate thesimilar set of two histograms in the lecture. You need to adjust the bin size to optimize the look of the histograms. Post both histograms,

2)Can you tweak the excel sheet a little to convert this exercise into acomputer simulation of the mechanical Galton machine? (hint: just change the function of x-bar column from average to something else, also the bin interval would be 0, 1, 2, 3,..., 30 to simulate there are 31 slots at the bottom)The difference is now we can increase the level and number of balls to a much larger number, and adjust p to any value. Try a few different parameter values. Describe what you did and post a histogram thatthat shows a computer simulation ofthe Galton machine.