70.2K

Verified Solution

Link Copied!

1. Let’s use Excel to simulate rolling two dice and ?nding therolled sum.

• Open a new Excel document.

• Click on cell A1, then click on the function icon fx andselect Math&Trig, then select RANDBETWEEN.

• In the dialog box, enter 1 for bottom and enter 6 for top.

• After getting the random number in the ?rst cell, click andhold down the mouse button to drag the lower right corner of this?rst cell, and pull it down the column until 25 cells arehighlighted. When you release the mouse button, all 25 randomnumbers should be present.

• Repeat these four steps for the second column, starting incell B1.

• Put the rolled sum of two dice in the third column: Highlightthe ?rst two cells in the ?rst row and click on AutoSum icon. Onceyou receive the sum of two values in the third cell, drag the lowerright corner of this cell, C1, down to C25. This will copy theformula for all 25 rows. We now have 25 trials of ourexperiment.

• Once these steps are completed, attach a screenshot of yourExcel ?le to your assignment.

(a) Find the probability that the rolled sum of both dice is5.

(b) Based on the results of our experiment of 25 trials, obtainthe relative frequency approximation to the probability found in(a).

(c) Repeat the simulation for 50 and 100 trials, and calculatethe relative frequency approximation to the probability in (a) foreach. Which approximation has the closest value to theprobability?

(d) Brie?y explain how these experiments demonstrate the Law ofLarge Numbers.