Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Mathematics questions

Question

Provide examples of supply chains in different industries.

Answered: 1 week ago