2016 Round 1, Section 3: Roll the Dice
Originally published: 16/07/2018 11:50
Publication number: ELQ-31237-1
View all versions & Certificate
certified

2016 Round 1, Section 3: Roll the Dice

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

Description
This workbook is taken from the 1st Round of the 2017 Modeloff financial modeling world championships.

Follow the instructions in order to complete the model:

You have been playing a game in which the rules are as follows:

- Each game consists of 2 turns.
- For each turn, roll one six-sided die 6 times, making a note of each number in the order it was rolled.
- Once you have your list of six numbers, determine the possible scores for the turn according to the categories below.
- For each game, score the game by finding the highest possible combined score from the twoturns, noting that no category may be used more than once (i.e. you may not score the two hands in the same category).

As you have a keen interest in statistics, you have decided to simulate several games in Excel and analyze the resulting scores. Questions 20 to 26 require only the ‘turn’ results. Questions 27 to 29 require analysis of the ‘game’ results.

The workbook provided contains dice rolls from 6,000 simulated turns (3,000 games). Use the rules below to first determine the possible scores for the turns, and then to find the highest possible score for each game. The rules on scoring turns can be found in the attached PDF file.

Allotted time: 36 minutes

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

This Best Practice includes
1 Excel Workbook & 1 PDF File

Full Stack Modeller offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss


5.0 / 5 (4 votes)

please wait...