Question: Many dice games require using 2 dice to obtain an objective such as landing on GO or sending your piece home or collecting resources. These

Many dice games require using 2 dice to obtain an objective such as landing on GO or sending your piece "home" or collecting resources. These games like Monopoly, Sorry and Settlers of Catan or very popular due there unpredictable chance attribute to their game. But what if we understand the odds better or see through the probability of rolling 2 dice. That is the purpose of this summative. You must explore the Theoretical and Experimental probability of rolling 2 dice using the random number generator in excel. You will setup and Excel file with 2 columns (1 for each dice) and copy =ROUND(6*RNAD()+0.5) to each column and drag it down into 80 rows for 80 simulations. You will then have a third column adding the 2 dice together. You are then tasked to tally the distributions and graph them and answer the questions .EXPERIMENTAL PROBABILITY

Many dice games require using 2 dice to obtain an objective such

2. Directions: Work individually. Roll two dice 80 times using the random number generator on excel, record the sums and complete the table. The command is =ROUND(6*RAND()+0.5) for each dice rol sum Tally Fraction Decimal Percentage ld or 1 2 kas 3 4 Its ate 9 10 11 12 3. Graph the distribution using excel. 4. Does it appear that the odds to roll each sum are equal? Explain. 5. Which sums seem to have the least chance of occurring? Why do you think that is? 6. Which sums seem to have the greatest chance of occurring? Why do you think that is

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!