Question
Students are to create a game on Excel depicting two players rolling a fair six-sided die. The rules of the game are simple. The player
Students are to create a game on Excel depicting two players rolling a fair six-sided die. The rules of the game are simple. The player that rolls the biggest number (1 6) wins. Students are to play at least 500 rounds, analyzing the results after every 100 rounds. Students are to interpret the findings accordingly and with as much accuracy as possible. Students will analyze the probability of success in various ways. See chart below. What is happening to the percentage of successes for Player 1, Player 2, and Ties?
Please write the steps on how to create the following game on excel. All the different formulas that are used in excel to create the 500 rounds. how to label the 500 rounds, and each round, please explain it all.
The spreadsheet is set up this way:
Title | |||||||
Round | Player 1 | Player 2 | Winner | Number of succeses (P1,P2,Ties) | % of wins (P1,P2,Ties) | P1 % of Rolls of 1,2,3,4,5, and 6 | P2 % of Rolls of 1,2,3,4,5, and 6 |
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