Roll two dice 10 times. Record the sum of the dice for each roll. Find the mean,
ID: 3134038 • Letter: R
Question
Roll two dice 10 times. Record the sum of the dice for each roll. Find the mean, standard deviation, and construct a histogram from the data. Roll two dice 50 times. Record the sum of the dice for each roll. Find the mean, standard deviation, and construct a histogram from the data. Roll two dice 100 times. Record the sum of the dice for each roll. Find the mean, standard deviation, and construct a histogram from the data. Summarize your findings by discussing the statistical implication of your findings.Explanation / Answer
Instead of rolling the dice I will create a simulation which gives random results of what could happen when we roll two dices. I will use the function rand in EXCEL.
For part 1 , 2 and 3 please look up in the excel file.
https://www.dropbox.com/s/t60ab8gok35bk8n/sum%20of%20dice.xlsx?dl=0
Please download the file from above link.
Part 4.
As the number of simulations increase, the histogram becomes more and more symmetric.