Simulating league tables
VBA Telemetry pings you when your VBA projects fail
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Simulating league tables

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    hi there.

    I am trying to construct a simulation to see the distribution of odds associated with predicting the top6 in a league of 20 or so teams.

    I suspect this would involve some monte carlo type simulation, but with the additional burden of sampling without replacing. I wonder if anyone out there has done something like this.

    RET79

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi,

    http://www.webace.com.au/~balson/InsaneExcel/Pretty.htm

    the last file has something which may be of use.

    Also, here is a bit of a primer on Monte Carlo simulation and Excel.

    http://www.geocities.com/WallStreet/9245/

    Another link:

    http://www.tushar-mehta.com/

    choose the SIMULATE option


    Your task will take a long time to set up and use properly, I believe. @Risk and Crystal Ball have add-ins for purchase for this.

    http://www.decisioneering.com for Crystal Ball
    http://www.palisade.com for @Risk (I think).

    HTH,
    Jay

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    England, UK.
    Posts
    526
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Jay, that's awesome!

    And isn't that horse thing cool!

    All the best,

    RET79

  4. #4
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-04-15 20:46, RET79 wrote:
    Jay, that's awesome!

    And isn't that horse thing cool!

    All the best,

    RET79
    I agree!! That horse race is possibly the coolest thing I've seen anyone do with Excel.

    Dermot is amazing.

    Bye,
    Jay

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com