Question: Construct a spreadsheet simulation model to simulate 10,000 rolls of a die with the six sides numbered 1,2, 3, 4, 5 and 5. 5. Construct


Construct a spreadsheet simulation model to simulate 10,000 rolls of a die with the six sides numbered 1,2, 3, 4, 5 and 5. 5. Construct a histogram of the 10,000 observed dice rolls. 6. For each roll of two dice, record the sum of the dice. Construct a histogram of the 10,000 observations of the sum of two dice. 7. For each roll ofthree dice, record the sum of the dice. Construct a histogram of the 10,000 observations of the sum ofthree dice. 8. Compare the histograms in parts (a), (bl and (c). What statistical phenomenon does this sequence of charts illustrate? (Hint: see Appendix 14.2)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
