2012 Round 2: Monte Carlo
Originally published: 23/07/2018 14:49
Publication number: ELQ-70106-1
View all versions & Certificate

2012 Round 2: Monte Carlo

Excel training/competition model from the 2012 Financial Modeling World Championships

This workbook is taken from the 2nd round of the 2012 Modeloff financial modeling world chamionships.

Follow the instructions in order to complete the model:


A friend has approached you asking for help estimating the winning odds on a heavily modified variation of a popular dice game. His version of the game works as follows:

• The player rolls 3 dice, each die has 6 sides
• If the total rolled is 3,4,5,16,17 or 18 the player loses
• If the total rolled is 7 or 11 the player wins
• If any other number is rolled, the player rolls again
• Rerolls work the same way as the initial roll, except that if the player rolls the same number as their first roll they win. For example if the player rolls 15-13-6-15 they would win

You quickly identify this as a statistical problem but given the complexity and the fact that you slept through most of your statistics classes at university, you decide to use a Monte Carlo simulation to estimate the odds.

When preparing your analysis you should assume the following:

• No more than 50 rolls are required to achieve a result
• 5000 outcomes are required to prepare your Monte Carlo.

For simplicity, you should use a Data Table to run your Monte Carlo.

Allotted time: 20 minutes

Once finished, feel free to upload your model to your own dedicated author channel!

This Best Practice includes
1 Excel Workbook, 1 PDF

Full Stack Modeller offers you this Best Practice for free!

download for free

Add to bookmarks


5.0 / 5 (6 votes)

please wait...