12 Monte Carlo Examples

12 Monte Carlo Examples - Uses the "RANDBETWEEN"...

Info iconThis preview shows pages 1–6. Sign up to view the full content.

View Full Document Right Arrow Icon
Uses the "RANDBETWEEN" and "COUNTIF" functions Dice 1 2 3 4 5 max Outcome Count 2 6 1 1 2 6 1 #NAME? 6 4 1 3 2 6 2 #NAME? 1 2 1 5 3 5 3 #NAME? 2 5 1 4 3 5 4 #NAME? 6 6 3 2 2 6 5 #NAME? 4 4 6 4 6 6 6 #NAME? 6 2 5 5 5 6 total #NAME? 0 3 5 2 5 4 5 6 2 2 1 3 6 3 4 4 2 3 4 3 3 3 3 6 6 4 4 5 2 3 5 2 6 6 3 1 6 1 3 1 3 1 3 1 5 4 2 1 5 4 3 5 2 2 5 6 4 6 1 2 6 1 5 2 3 2 5 5 5 1 6 2 6 1 5 6 5 1 6 1 1 3 3 5 5 2 1 4 2 6 6 1 5 3 3 6 6 6 5 5 1 1 6 3 5 2 6 6 6 4 6 6 4 2 6 5 1 5 5 3 5 6 6 6 5 5 6 5 5 5 3 2 5 5 3 2 1 5 5 6 6 6 6 3 6 6 5 6 4 4 6 4 1 2 3 1 4 1 2 6 4 5 6 2 3 6 1 1 6 4 1 5 5 3 5 4 6 6 1 5 6 1 5 4 6 5 6 6 5 6 4 6 6 3 1 1 2 2 3 4 2 2 1 2 4 3 1 3 1 6 6 1 4 6 4 4 6 5 1 1 4 2 5 3 3 4 3 6 6 1 3 3 6 5 6 3 3 6 5 3 6 3 6 3 3 2 6 1 1 5 3 1 5 1 2 1 4 5 5 3 5 3 2 2 5
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
2 2 1 5 5 5 3 2 4 6 4 6 4 4 5 4 2 5 1 6 6 5 6 6 5 1 5 6 4 6 1 4 4 1 3 4 6 1 4 4 3 6 4 1 5 4 2 5 6 3 3 3 5 6 4 4 6 4 1 6 4 1 5 3 5 5 6 1 2 1 3 6 2 4 1 1 2 4 4 2 5 6 3 6 1 3 2 1 3 3 5 4 5 6 4 6 2 2 5 1 2 5 2 1 6 1 2 6 5 3 5 4 4 5 5 2 5 3 3 5 5 3 1 2 4 5 1 3 1 4 3 4 5 6 5 1 1 6 4 3 2 5 5 5 4 6 4 1 3 6 5 3 1 6 5 6 1 6 1 3 2 6 6 6 6 4 4 6 6 3 5 2 6 6 1 1 1 1 6 6 3 5 2 5 6 6 2 4 6 6 4 6 4 3 4 1 4 4 1 3 1 2 1 3 3 4 5 5 4 5 2 4 3 6 1 6 1 6 4 3 3 6 2 4 3 3 1 4 6 4 2 4 3 6 1 2 6 6 2 6 6 2 2 6 2 6 4 5 1 6 1 6 6 2 1 6 4 6 1 5 3 1 3 5 2 6 5 6 4 6 6 5 3 1 1 6 6 3 1 1 6 6 3 2 3 1 5 5 2 6 2 1 2 6 4 5 5 4 3 5 2 3 2 3 2 3 1 2 2 2 5 5 4 2 5 2 6 6 6 3 6 4 2 6
Background image of page 2
5 5 3 1 4 5 2 2 3 3 2 3 5 5 1 3 1 5 5 5 4 3 6 6 2 2 2 6 6 6 5 2 5 4 6 6 6 6 4 4 6 6 4 1 4 4 5 5 6 6 5 4 4 6 3 3 2 4 3 4 4 3 4 6 6 6 2 3 3 3 2 3 5 6 5 3 4 6 5 3 1 2 3 5 4 1 6 5 2 6 5 4 1 6 6 6 5 5 1 1 4 5 3 3 1 5 3 5 3 2 1 6 1 6 4 1 2 1 1 4 4 1 3 6 5 6 4 2 6 6 4 6 4 5 4 1 1 5 3 4 4 6 5 6 1 3 3 6 3 6 6 5 5 2 3 6 1 3 2 4 2 4 2 6 5 3 4 6 1 1 1 3 2 3 5 4 1 6 1 6 2 2 4 6 6 6 5 6 3 3 6 6 6 6 3 2 3 6 6 1 5 3 6 6 4 5 6 6 5 6 1 1 5 2 3 5 5 2 4 6 6 6 4 4 4 3 5 5 5 1 2 5 2 5 4 1 2 4 3 4 1 6 6 1 1 6 2 4 6 5 1 6 6 4 5 6 4 6 6 6 4 3 4 6 1 6 1 1 3 6 3 5 4 5 6 6 5 3 5 3 4 5 5 4 1 2 6 6 6 1 4 3 2 6 1 4 5 3 5 5 3 5 3 2 1 5 3 1 1 3 1 3 4 6 5 3 3 6 1 3 6 2 2 6
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
6 5 4 3 6 6 4 2 1 2 5 5 6 2 5 4 4 6 6 1 6 1 1 6 6 1 6 5 3 6 6 3 5 1 6 6 5 5 1 6 2 6 1 3 4 5 3 5 5 2 2 3 5 5 4 4 4 2 5 5 1 3 2 1 2 3 3 6 2 3 4 6 4 4 2 3 1 4 5 5 5 1 2 5 6 4 6 6 2 6 2 5 4 2 2 5 3 5 6 4 4 6 1 3 5 6 3 6 4 2 4 6 3 6 2 3 4 4 2 4 6 3 3 3 1 6 4 2 4 6 5 6 5 1 2 2 1 5 4 5 1 6 5 6 3 6 5 1 5 6 4 1 5 5 2 5 4 3 6 2 3 6 6 4 2 3 5 6 1 2 6 1 3 6 2 2 5 4 5 5 6 1 2 5 6 6 1 6 3 3 2 6 6 4 6 6 4 6 6 2 6 2 4 6 1 6 3 3 2 6 5 4 5 5 1 5 6 4 5 2 3 6 5 5 3 3 4 5 6 6 2 4 3 6 5 6 1 5 2 6 2 2 1 4 2 4 6 3 3 5 5 6 1 5 3 1 6 6 6 6 3 1 2 6 4 1 1 5 6 6 1 3 2 6 1 6 2 4 1 2 4 4 1 6 1 3 4 6 1 5 1 6 4 6 6 6 4 2 6 6 2 2 5 1 5 5 1 2 3 2 4 4 4 2 2 2 5 5 1 2 6 3 5 6
Background image of page 4
4 6 4 2 2 6 6 1 1 2 3 6 4 2 5 1 1 5 2 3 4 3 4 4 6 5 2 5 2 6 5 3 4 2 3 5 3 5 2 1 3 5 5 5 3 3 1 5 6 3 1 5 5 6 2 2 1 1 1 2 5 1 3 4 5 5 6 3 3 2 1 6 1 6 5 5 1 6 5 5 1 5 2 5 5 1 6 5 4 6 6 5 1 3 4 6 3 4 2 3 4 4 1 2 1 3 5 5 6 2 3 1 2 6 3 3 4 4 3 4 6 1 3 3 1 6 4 2 4 6 2 6 4 5 5 4 4 5 2 5 3 4 5 5 4 1 4 2 5
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 228

12 Monte Carlo Examples - Uses the "RANDBETWEEN"...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online