Explore BrainMass

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

    ADVERTISEMENT