Question: 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

In assignment one you will use your skills to
In assignment one you will use your skills to
In assignment one you will use your skills to
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 sim extension Datac Generate 10,000 data points from a uniform 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, 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, 10, 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. 4:11

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!