Explore BrainMass
Share

Simulation-Dice Rolls in Excel

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

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.

© BrainMass Inc. brainmass.com March 22, 2019, 3:44 am ad1c9bdddf
https://brainmass.com/business/finance/simulation-dice-rolls-in-excel-631358

Attachments

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 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.

$2.19