Welcome Guest
Log In | Register )
You last visited December 10, 2016, 7:11 pm
All times shown are
Eastern Time (GMT-5:00)

Excel Draw Simulation vs Actual Draws

Topic closed. 5 replies. Last post 3 years ago by LottoBoner.

Page 1 of 1
PrintE-mailLink
TooTallLuke's avatar - img 8jc7G2.jpg
Ontario
Canada
Member #137286
December 31, 2012
93 Posts
Offline
Posted: November 12, 2013, 7:33 am - IP Logged

Anyone use Excel to simulate draw results to back check system ideas? Whats nice with Excel is I can simulate over 1 million draws for either Keno, 649, pick 4 etc. Problem is usually with the simulated draw results the average number of times a number, or number set will appear is greater then with actual draw results? Was wondering if anyone else has run into this issue? Wondering if maybe it's Excel's RNG function that causes it??

    SergeM's avatar - slow icon.png
    Economy class
    Belgium
    Member #123700
    February 27, 2012
    4035 Posts
    Offline
    Posted: November 12, 2013, 2:20 pm - IP Logged

    Prediction Statistics for TooTallLuke

    No report available: TooTallLuke has not posted any predictions.

      SergeM's avatar - slow icon.png
      Economy class
      Belgium
      Member #123700
      February 27, 2012
      4035 Posts
      Offline
      Posted: November 12, 2013, 2:30 pm - IP Logged

      James?


        United States
        Member #124493
        March 14, 2012
        7023 Posts
        Offline
        Posted: November 12, 2013, 4:03 pm - IP Logged

        Anyone use Excel to simulate draw results to back check system ideas? Whats nice with Excel is I can simulate over 1 million draws for either Keno, 649, pick 4 etc. Problem is usually with the simulated draw results the average number of times a number, or number set will appear is greater then with actual draw results? Was wondering if anyone else has run into this issue? Wondering if maybe it's Excel's RNG function that causes it??

        There is an interesting video on YT with the RNG function. I thought to make it.  But who has the time?

        However the problem with stimulations is that, if your million game stimulation has a result where the number one hits 700,000 times, but in real life it hits 250,000 times, how do you plan to hope to cope with that stimulating discrepancy in real world wagering?

        If you have actual result there is no real need for stimulations.  Just acute observations.

          TooTallLuke's avatar - img 8jc7G2.jpg
          Ontario
          Canada
          Member #137286
          December 31, 2012
          93 Posts
          Offline
          Posted: November 13, 2013, 7:32 am - IP Logged

          Could you post the link to the video on YT with the RNG function? I checked YT and there's tons on videos on Excel RNG function, but was there something in peticular you wanted me to see?


            United States
            Member #124493
            March 14, 2012
            7023 Posts
            Offline
            Posted: November 14, 2013, 5:09 pm - IP Logged

            Could you post the link to the video on YT with the RNG function? I checked YT and there's tons on videos on Excel RNG function, but was there something in peticular you wanted me to see?

            I dont know how well it will serve you.  I just thought the whole concept was interesting and the functions and blah blah stuff were kinda cool.

            I am not into RNG per se, although I may do this for fun one day, and also just to expand my excel knowledge.

            I prefer to let the numbers paint a picture and a story, and then I make an artistic guess.  Not that I would pay $99 for a Lotto Abstract!