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.
The task is to simulate a roll of a PAIR of dice--each die having equal probabilities of outcomes: 1, 2, 3, 4, 5 or 6.
Perform 50 trials of this simulation. What is the expected value of the dice roll (minimum value is 2; two 1's rolled; maximum value of the throw is 12; two 6's rolled)?
To perform this simulation, we must use Excel on its own, or Crystal Ball (simulation software add-in for excel).
How do I set this up in Excel? Would I have to use like a random # generator to simulate a random 50 throws of the dice???
© BrainMass Inc. brainmass.com March 4, 2021, 5:50 pm ad1c9bdddfhttps://brainmass.com/statistics/probability/set-up-simulated-dice-rolling-excel-13746
Solution Preview
please see the attachment.
My suggestion. You can do this by using Excel. Since the task is to simulate a roll of a PAIR of dice--each die having equal probabilities of outcomes: 1, 2, 3, 4, 5 or 6, we have 36 possible cases. (1,1), (1,2),(1,3),(1,4),(1,5),(1,6)
(2,1), (2,2),(2,3),(2,4),(2,5),(2,6)
(3,1), (3,2),(3,3),(3,4),(3,5),(3,6)
(4,1), (4,2),(4,3),(4,4),(4,5),(4,6)
(5,1), (5,2),(5,3),(5,4),(5,5),(5,6)
(6,1), (6,2),(6,3),(6,4),(6,5),(6,6)
each of them appears at the same probability ...
Solution Summary
The following solution outlines the process by which you can program Excel to simulate a pair of rolling die.