Explore BrainMass

# How to set up simulated dice rolling in Excel.

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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 ad1c9bdddf
https://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.

\$2.49