Welcome Guest
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
Ontario
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??

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.

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.

Ontario
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!

 Page 1 of 1