Purchase Solution

Simulation-Dice Rolls in Excel

Not what you're looking for?

Ask Custom Question

Develop two simulation models of tossing two six-sided dice (numbered 1 through 6 on the six faces).
Model 1: Simulate rolling a single die twice and add the total.
Model 2: Simulate a combined roll of two dice, giving a number from 2 through 12 with appropriate probabilities.

Attachments
Purchase this Solution
Solution Summary

An Excel file containing 2 simulations is provided. A paragraph has been written for each of the 2 simulations, describing how the simulations were performed.

Solution Preview

Model 1
Excel was used to generate integer random numbers from 1 to 6 inclusive, to simulate rolls of both the first and second die. The results are displayed in the Excel spreadsheet. The total of the two dice rolls was computed and displayed ...

Solution provided by:
J Pye, MSc
Education
  • MSc, California State Polytechnic University, Pomona
  • MBA, University of California, Riverside
  • BSc, California State Polytechnic University, Pomona
  • BSc, California State Polytechnic University, Pomona
Recent Feedback
  • "Excellent work. Well explained."
  • "Can you kindly take a look at 647530 and 647531. Thanks"
  • "Thank you so very much. This is very well done and presented. I certainly appreciate your hard work. I am a novice at statistics and it is nice to know there are those out there who really do understand. Thanks again for an excellent posting. SPJ"
  • "GREAT JOB!!!"
  • "Hello, thank you for your answer for my probability question. However, I think you interpreted the second and third question differently than was meant, as the assumption still stands that a person still independently ranks the n options first. The probability I am after is the probability that this independently determined ranking then is equal to one of the p fixed rankings. Similarly for the third question, where the x people choose their ranking independently, and then I want the probability that for x people this is equal to one particular ranking. I was wondering if you could help me with this. "
Purchase this Solution
Free BrainMass Quizzes
Lean your Process

This quiz will help you understand the basic concepts of Lean.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Academic Reading and Writing: Critical Thinking

Importance of Critical Thinking

View More Free Quizzes
Related BrainMass Solutions

  • rolling die simulation

    Show the sum in column D. Repeat the simulation for 1000 rolls of the dice. What is your simulation estimate of the probability of rolling a7? please see the attached file. You can press F9 and the simulation changes.

  • Simulation of random numbers using STATDISK

    96236 Simulation of random numbers using STATDISK Probabilities through Simulations 1)Dice Simulation - Use Statdisk to simulate 1000 rolls of a pair of dice.

  • How to set up simulated dice rolling in Excel.

    13746 How to set up simulated dice rolling in Excel. I have to create a simulation in Excel or Crystal Ball (an Excel add-in)only; no other software choices.

  • Central Limit Theorem

    On the first roll of 5 dice and 1,000 rolls it was as normal as with 5 dice / 100 rolls was on the 4th roll. On the first roll of 5 dice and 10,000 rolls it was almost perfectly normal. ?

  • Probability in 200 Dice Rolls

    164026 Probability in 200 Dice Rolls Find the probability that in 200 tosses of a fair six-sided die, a five will be obtained at most 40 times. Please provide the detail of how to calculate. Please see the attached file.

  • An experiment based discussion of the Central Limit Theorem

    at a time 2 dice, 1000 rolls at a time 5 dice, 10 rolls at a time 5 dice, 100 rolls at a time 5 dice, 1000 rolls at a time And because you are curious "if your computer allows" go ahead and try the experiment again with 10,000 rolls at a time

  • Understanding the Central Limit Theorem.

    distribution will not be normal it will be uniform in all cases. 2 dice, 10 rolls at a time 2 dice, 100 rolls at a time 2 dice, 1000 rolls at a time With two die we get the distribution I outlined above.

  • Frequencies of Dice Roll Combinations and Probabilities of Dice Rolls

    43720 Frequencies of Dice Roll Combinations and Probabilities of Dice Rolls When a pair of dice is rolled, the total will range from 2 (1,1) to 12 (6,6).

  • Probability of Rolling of the Die

    Expected return and standard deviation are calculated in the attached Excel file. Problem 1 and 2 are discussed in 82 words in the attached Word document along with the outcomes for the different die roles.

View More Related Solutions