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

Calculate your order
275 words
Total price: $0.00

Top-quality papers guaranteed

54

100% original papers

We sell only unique pieces of writing completed according to your demands.

54

Confidential service

We use security encryption to keep your personal data protected.

54

Money-back guarantee

We can give your money back if something goes wrong with your order.

Enjoy the free features we offer to everyone

  1. Title page

    Get a free title page formatted according to the specifics of your particular style.

  2. Custom formatting

    Request us to use APA, MLA, Harvard, Chicago, or any other style for your essay.

  3. Bibliography page

    Don’t pay extra for a list of references that perfectly fits your academic needs.

  4. 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

Type of paper
Academic level
Deadline
550 words

How to place an order

  • Choose the number of pages, your academic level, and deadline
  • Push the orange button
  • Give instructions for your paper
  • Pay with PayPal or a credit card
  • Track the progress of your order
  • Approve and enjoy your custom paper

Ask experts to write you a cheap essay of excellent quality

Place an order