Microsoft Excel “Roll of the Die”
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 the chart below. What is happening to the percentage of successes for Player 1, Player 2, and Ties? Recall the Rock, Paper, Scissor game. What is happening to the percent of successes for values 1 – 6 as more rounds are played?
The spreadsheet should have the following information:
“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
*Note1: For [P1 – % of Rolls of 1,2,3,4,5, and 6] and [P2– % of Rolls of 1,2,3,4,5, and 6] what I want from you is to analyze the % of times each number is rolled over the course of all the rounds. Theoretically, each value has an equal chance of being rolled. The idea is to see if the more rounds that are played; do we slowly get to a place where there is an equal percent of rolls for each value?
*Note2: Student retains artistic freedom to display/outline their spreadsheet how they see fit.
Requirements:
· A spreadsheet of at least 500 rounds
· A clear, easy-to-read, data spreadsheet
· Accurate formulas to achieve desired goals
· A brief synopsis of the findings
Top-quality papers guaranteed
100% original papers
We sell only unique pieces of writing completed according to your demands.
Confidential service
We use security encryption to keep your personal data protected.
Money-back guarantee
We can give your money back if something goes wrong with your order.
Enjoy the free features we offer to everyone
-
Title page
Get a free title page formatted according to the specifics of your particular style.
-
Custom formatting
Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.
-
Bibliography page
Don’t pay extra for a list of references that perfectly fits your academic needs.
-
24/7 support assistance
Ask us a question anytime you need to—we don’t charge extra for supporting you!
Calculate how much your essay costs
What we are popular for
- English 101
- History
- Business Studies
- Management
- Literature
- Composition
- Psychology
- Philosophy
- Marketing
- Economics