Discuss the below:
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