FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
  • FIFA World Cup 18 - Monte Carlo Simulation Model
Originally published: 13/06/2018 06:34
Publication number: ELQ-21664-1
View all versions & Certificate
certified

FIFA World Cup 18 - Monte Carlo Simulation Model

FIFA World Cup 18 Monte Carlo Simulation Model

Description
FIFA World Cup 18 Monte Carlo Simulation Model, based on sport betting odds and providing estimated odds of winning for every national squad.

Model includes the combination of RAND function and data tables to create a repetitive stochastic process.

Same combination can be used for other simulation, providing an interesting alternative to more complex programming tools, such as VBA or MATLAB.

This Best Practice includes
1 Excel Model

Rafael Le Saux, CFA, AFM offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Further information

Using simple excel tools for simulation

Large samples of data

N/A

Reviews

keyboard_arrow_downShow all


keyboard_arrow_leftkeyboard_arrow_right

Discussion feed for FIFA World Cup 18 - Monte Carlo Simulation Model

The user community and author are here to help. Go ahead!

  • Reto Wernli
    Hi Rafael. I don't seem to get how you initiate the Simulation to fill the Columns C, F, I and L in Sheet "Monte Carlo".
    Thanks for your help.
    arrow_drop_uparrow_drop_downReply reply
    • Rafael Le Saux, CFA, AFM
      Hi Reto,

      Thank you for your message.

      Have you tried pressing F9 to recalculate?

      Please let me know if that works.

      Best Regards
      1arrow_drop_uparrow_drop_downReply reply


    4.8 / 5 (13 votes)

    please wait...