Assignment One In assignment one you will use your skills to generate random data in Microsoft Excel and run simulations on that data using macros. Remember to save your file as a "Excel Macro-Enabled Workbook" which gives the .xlsm extension. Data: Generate 10,000 data points from a uniforrls distribution between 20 and 30. You can do this using the "Random Number Generation" tool in the Data Analysis toolbox. Everyone will have a different data set (they're all random). From this population, vou will select samples of 5.10 and 25 and calculate the average of each From this population, you will select samples of 5, 10 and 25 and calculate the average of each sample. Repeat this 1,000 times so that you have three datasets of 1,000 averages - as we did in class on 02 May 2020. Generate histograms for each of the datasets. There should be four histograms - one for the population and one for each of the three sample groups (n = 5, n. 10, n = 25). Calculate the standard deviation of your four columns of data. Compare these values to the estimates given the formula on page 78 of the course textbook. Discuss - provide 2 or 3 comments about the shape and width of the histograms. Assignment One In assignment one you will use your skills to generate random data in Microsoft Excel and run simulations on that data using macros. Remember to save your file as a "Excel Macro-Enabled Workbook" which gives the .xlsm extension. Data: Generate 10,000 data points from a uniforrls distribution between 20 and 30. You can do this using the "Random Number Generation" tool in the Data Analysis toolbox. Everyone will have a different data set (they're all random). From this population, vou will select samples of 5.10 and 25 and calculate the average of each From this population, you will select samples of 5, 10 and 25 and calculate the average of each sample. Repeat this 1,000 times so that you have three datasets of 1,000 averages - as we did in class on 02 May 2020. Generate histograms for each of the datasets. There should be four histograms - one for the population and one for each of the three sample groups (n = 5, n. 10, n = 25). Calculate the standard deviation of your four columns of data. Compare these values to the estimates given the formula on page 78 of the course textbook. Discuss - provide 2 or 3 comments about the shape and width of the histograms