Ontario Canada
Member #137,280
December 31, 2012
106 Posts
Offline
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??
United States
Member #124,487
March 14, 2012
7,021 Posts
Offline
Quote: Originally posted by TooTallLuke on Nov 12, 2013
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.
Ontario Canada
Member #137,280
December 31, 2012
106 Posts
Offline
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 #124,487
March 14, 2012
7,021 Posts
Offline
Quote: Originally posted by TooTallLuke on Nov 13, 2013
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!