For this exercise, you are going to estimate the probability of an event using simulations. A simulation of a procedure is a process that behaves the same way as the procedure, so that similar results are produced. Instructions: – Open a blank Excel workbook. – Simulate 600 rolls of a single fair die. In order to do this, you will need to use a random number generator.
Two options are “RAND” and “RANDBETWEEN.” Use the one that is appropriate. – Construct a frequency distribution table for the outcomes that have been simulated. – Based on 600 theoretical rolls of a fair die, construct a frequency distribution table for the outcomes. How does this distribution compare to the simulation?
What is the largest percent difference between theory and simulation? – Open a second worksheet in the same workbook. Follow the previous 3 instructions for 6000 rolls of a single die. – Based on your two simulations, what would you expect to see regarding the percent differences between simulated and theoretical if you were to simulate 60000 rolls of a single fair die?
What about 600000 rolls? You will be submitting the Excel file that you have created and a Word document with a reproduction of the tables constructed in Excel and the answers to the questions. When done, save your files with the name form “mcjiltontechexercise4”, where you use your last name instead of mine. Upload the files here.