please solve the whole problem or leave it for someone who will .

*** please ( include Excle VBA code for the program )

2 Coin Flipping Distribution/Central Limit Theorem This problem will use coin flipping to investigate the effect of varying the total number of discrete tests on the resulting statistical distributions of the results. a) write a program that will simulate 20 consecutive coin flips per test. Ifthe result is a head, add running t the tails, one Ci) from the total For example, if the result of the test is12 heads and 8 tails, the corresponding total for the test is positive four (+4) b) estigate the distribution of the resulting values for the following total number of 5 tests. 25 tests 100 tests 500 tests 5.000 tests 50,000 tests 250,000 tests For each set of tests, comment on the primary observations regarding the distribution. What type of distribution is achieved for experimen with large of tests? Extra Credit: calculate the corresponding average and standard deviation forthe results for each experiment (either in VBA code or using built-in spreadsheet functions). Use these metrics to calculate the percentage of data points that fall within: Au-3or to 20 H-20 to Au-lo H- to H +or H o to 20 Compare the corresponding results with the Empirical rule. What conclusions can you draw? How are the conclusions affected by the total number of tests performed? 2 Coin Flipping Distribution/Central Limit Theorem This problem will use coin flipping to investigate the effect of varying the total number of discrete tests on the resulting statistical distributions of the results. a) write a program that will simulate 20 consecutive coin flips per test. Ifthe result is a head, add running t the tails, one Ci) from the total For example, if the result of the test is12 heads and 8 tails, the corresponding total for the test is positive four (+4) b) estigate the distribution of the resulting values for the following total number of 5 tests. 25 tests 100 tests 500 tests 5.000 tests 50,000 tests 250,000 tests For each set of tests, comment on the primary observations regarding the distribution. What type of distribution is achieved for experimen with large of tests? Extra Credit: calculate the corresponding average and standard deviation forthe results for each experiment (either in VBA code or using built-in spreadsheet functions). Use these metrics to calculate the percentage of data points that fall within: Au-3or to 20 H-20 to Au-lo H- to H +or H o to 20 Compare the corresponding results with the Empirical rule. What conclusions can you draw? How are the conclusions affected by the total number of tests performed