We’re going to do an activity where we roll dice and think about the distributions of the averages of our rolls.
Use the Excel file below to record your rolls for this activity.
external/sheets/DiceRollBlank.xlsx
(If you don’t have dice, you can use the tool below.)
(a)
Roll a die at least 20 times. Use the Excel file above to record what you get on each roll. Then use the Data Analysis “Histogram” tool to visualize the distribution of rolls with the “Bins” \(1,2,3,4,5,6\text{.}\) (Before visualizing the rolls, think about what you expect the distribution to look like.)
(b)
Now roll 2 dice and in the next sheet of the Excel file, record those two rolls and then find the average of those two rolls. Repeat this at least 20 times. Use Excel to create a histogram of the averages.
(c)
Now roll 3 dice and in the next sheet of the Excel file, record those three rolls and then find the average of those three rolls. Repeat this at least 20 times. Use Excel to create a histogram of the averages.
(d)
Next we want to do this for averages of a larger number of rolls. But this is rather time-consuming, so we’re going to use the link below to see how this would work if we rolled many more dice and looked at the distribution of the averages:
https://math.bu.edu/people/rmagner/CLTdemo.html