Excel Instructions:

Open a new Excel Blank Workbook

A$.$ Begin with header Sim $1($Centered$,$ Bold$)$ in cell B$1($Sim $1$ for simulation $1)$

B$.$ In cell B$2$ put the sum of the dice by entering the following function, and hitting Tab:

$=$ SUM$($RANDBETWEEN$(1,6),$ RANDBETWEEN$(1,6))$

C$.$ Drag this formula down to row $26,$ creating $25$ such rolls of the sum of two dice

$($click into B$2,$ go to lower right corner to get black plus symbol, then drag down$)$

D$.$ Go to cell A$27,$ and place header AVG $($Bold$,$ Aligned to the Right or Right$-$Justified$)$

E$.$ Go to cell B$27,$ and enter $=$AVERAGE$($B$2$:B$26)($round it to two decimal places$)$

F$.$ Highlight B$1$:B$27,$ go to lower right corner $($of highlighted area$)$ to get black plus sign,

and drag across to the RIGHT to generate $40$ total simulations$-$be sure to include

headers. Delete additional columns if you go too far. You should have $27$ rows $x41$

columns $($including headers$)$

G$.$ Round all the averages to two decimal places $($highlight the bottom row and round so

every average is to two decimal places$).$

Now, we want to find and display the mean of the samples means, or the average of the $40$

averages.

H$.$ Place new header $($MEAN$)$ in A$28($Bold$,$ Right$-$justified$),$ put the mean or average of the

sample means into B$28$ and round to two decimal places $($using $=$AVERAGE$()$ again$).$

I. Open and close your workbook several times, creating new simulations and note the

Mean of the Sample Means each time. Compare the few means of the sample means to

the $40$ individual means. What do you observe? Write your observation in Cell A$29$ in

Excel workbook.