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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started