Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Databases questions