Trying to find new ways to crunch numbers

Working off of Florida's Fantasy 5... Had high hopes for this data set but it doesn't look all that useful. The "num" column is just the ball number. The other columns are how often the number was out before being picked again. So like the number 2 row most commonly hits after only 1 day out. The whole data set only includes the year 2012 data. The last four years of data, all together, didn't look like much to work off of.

num out0 out1 out2 out3 out4 out5 out6 out7 out8 out9 out10
1 9 8 4 5 5 0 3 6 2 2 1
2 2 11 10 4 6 2 2 3 3 2 1
3 5 2 3 3 4 6 6 2 4 1 1
4 6 3 9 1 1 3 3 2 1 2 2
5 7 6 4 4 7 6 1 5 0 1 1
6 13 6 4 4 1 2 2 3 0 4 2
7 7 4 2 1 1 2 6 2 0 1 4
8 6 1 3 2 2 1 3 3 2 4 2
9 4 2 2 6 5 6 1 3 3 3 1
10 10 6 5 9 5 2 6 1 4 6 0
11 8 6 5 2 4 3 0 5 2 1 2
12 5 10 3 3 3 1 3 2 1 2 3
13 3 9 7 4 1 3 3 3 1 2 4
14 10 6 7 4 4 1 2 1 2 2 1
15 2 3 0 3 3 0 1 1 1 1 3
16 3 6 8 4 4 2 2 3 1 5 1
17 10 6 5 4 1 2 1 1 1 1 3
18 10 6 3 4 3 3 1 0 2 2 1
19 12 8 7 5 1 1 2 2 4 2 1
20 8 6 7 4 4 3 1 2 1 3 4
21 9 6 9 5 1 4 3 1 3 2 1
22 5 3 4 2 3 4 5 0 2 2 3
23 11 4 7 5 4 3 3 3 2 2 1
24 7 5 3 4 1 4 0 2 1 2 2
25 1 2 1 2 3 1 1 1 1 0 0
26 6 4 2 4 5 0 3 5 1 1 1
27 4 3 7 6 7 3 2 4 2 1 1
28 6 4 6 6 2 1 5 3 4 0 0
29 7 10 2 11 2 2 6 5 0 2 1
30 8 4 6 6 3 4 1 5 4 2 1
31 4 4 6 10 1 3 4 2 1 1 1
32 6 6 3 4 1 2 0 1 1 3 1
33 8 8 3 0 0 1 1 0 2 1 1
34 6 7 7 11 5 5 4 2 3 2 1
35 5 3 1 6 1 2 2 3 4 2 1
36 9 5 8 6 3 1 3 0 0 2 2

I'm really looking for different ways to break down historical data so I can throw it up on my website. Kinda running out of ideas. Any suggesstions?

Here's 2009 forward (combined) if anyone is interested

num out0 out1 out2 out3 out4 out5 out6 out7 out8 out9 out10
1 30 23 25 21 12 9 15 16 12 8 7
2 24 29 27 18 21 17 8 9 6 7 5
3 27 19 24 17 16 21 13 11 9 10 5
4 36 21 32 12 12 13 17 11 13 4 6
5 20 20 13 8 21 12 10 10 6 10 5
6 41 39 12 24 17 16 12 9 7 7 9
7 27 25 18 19 8 12 16 12 8 5 8
8 27 15 19 15 13 6 8 11 5 14 6
9 33 22 8 14 21 15 8 8 13 7 6
10 29 25 18 20 14 16 17 8 7 13 3
11 29 20 17 16 11 15 14 17 9 8 5
12 37 17 13 16 11 10 15 8 6 14 7
13 29 18 19 18 13 11 14 8 6 2 7
14 31 19 23 21 11 13 8 9 9 8 9
15 26 32 16 22 19 16 7 12 8 4 8
16 27 28 26 14 13 9 8 10 4 9 5
17 26 20 17 15 11 15 8 7 4 6 5
18 33 29 23 14 16 5 12 8 8 13 8
19 44 24 31 15 14 10 10 8 8 7 12
20 27 18 22 13 18 5 6 8 4 8 10
21 28 33 28 22 18 7 9 10 5 13 6
22 24 12 26 21 18 11 12 3 8 7 8
23 32 17 19 20 16 12 10 15 8 17 6
24 29 20 18 15 8 13 13 11 2 5 4
25 20 23 24 11 12 10 6 10 8 7 6
26 27 21 22 19 16 10 12 11 10 7 7
27 20 17 24 14 20 9 6 14 9 9 5
28 48 21 24 16 13 12 15 11 11 4 4
29 25 34 18 19 18 12 15 10 9 10 5
30 29 18 26 15 10 12 8 12 9 5 5
31 24 26 20 23 9 14 16 4 9 8 5
32 25 24 18 18 17 11 10 6 6 5 6
33 44 21 30 11 12 10 8 5 6 8 8
34 35 32 24 25 13 14 11 14 8 5 4
35 19 22 14 18 14 10 10 10 7 7 7
36 40 25 23 14 8 11 14 10 4 7 8

You can paste tables.

Oh... I just copied that from SSMS. Got tired of working in Excel so I moved to SQL. Easier to work with the data that way.

1/1/2012 - Current

1/1/2009 - current

Taking it further, here are the outs that hit with a zero day out for the month of October. This further supports the 46% chance of a zero day out occuring again (based on statistics). I wonder how this data would compare with common pairs.

Any input guys? There's gotta be some interesting ideas from this collective.

You know SQL so you must be an IT-professional.

What is your problem?

Hi,

  Very nice concept. I am just starting to work on it in Liberty Basic.

  My thoughts are using your current table by lotto number and comparing the value to the out of each number.

  ie if lotto number 1 is currently 3 games out, it would have a value of 3.

  I suspect if you track the results of each draw using the subject table, as fixed tabled values, you will end up with a low-high distribution when sorted.

  That could then be used as a postional filter with the corresponding boundry conditions..

  It will probably take me a month or two to verify the proof of concept.

  Thanks

Wish I wasn't a newbie so you could see the site I've been working on (can't post a link according to the site rules). For my base games, I have Powerball, FL Lotto, and Megamoney up and running. It pulls down the new numbers automatically and updates the base statistics for each game. I designed the framework so new games can be added with only a few hours of work (the site pulls in all of the historical data and crunches the numbers). So now I'm trying to expand the other way: What other interesting statistics can I add for each game that would be beneficial. The base stats I have are:

-Last games out: Statisticsly speaking, there's a 40.64 chance of a zero day out (number that came up on the last drawing) number occurring again for Powerball; based on almost four years worth of draws. So if you pick from the last 5 numbers (not including PB), there's a 40% chance one of those five numbers will hit vs. trying to figure out which of the other 54 balls have good odds.

-Number breakdown data set: This is a quick view of each number that shows the draws out, previous draws out, how often the number has occurred over 7 days, how often the number has occurred over 30 days, occurred year to date, occurred over 2011, and occurred over 2010. It's just a nice way to view what numbers might be hot or cold.

-Sums (not including PB/MB): Based on the historical data, we can see there's a sweet spot for the sums. If someone were to pick 1-2-3-4-5 for powerball, that's really bad odds (it's never won before). The sweat spot for powerball sums is 116 to 190. That's a nice gap, but having a sum within that range gives better odds.

-Odds/Evens: This data set shows there's another sweet spot for picking the right amount of odd and even numbers (again, the PB and MB are not included in the stats for those games, it would only sqew the data). I have over 400 records in my powerball table. Out of those 400 draws, all even numbers has occurred 9 times; not good odds. But, 2 odd/3 even has occurred 135 times. 3 odd/2 even has occurred 128 times. That doesn't help much with picking good combinations but when I finilize my numbers, I always make sure I have a good split; better odds that way.

-Matching numbers: Again, using powerball as an example... out of over 400 draws, a winning number has repeated zero times. So I always check to make sure my final play numbers haven't hit before.

So that's why I have for each game so far. Now I want to add more data sets. I think I'll add an 'out' data set to show what's been popular over the last 30 days or something. I'm curring writing a query that will tell me which outs pair well when a zero day out number hits (since there's a 40% chance of that happening for only five numbers). After that, I'm not sure what other data sets would be useful. So I was hoping a collective such as this would have some ideas. Looking for anything really. No such thing as a stupid idea.

Blinds please!

Blinds? I don't understand.

Look at RL-Randomlogic system and posts in the lottery systems forum. He has some excellent methods in his program.

In poker you place blinds to get cards. Translated this means that you don't know which two cards you will get.

Your charts are still basic and those can be found in several programs. Also you made no conclusion, you didn't decide what to play. You have no strategy. All you did was making charts that are as old as the moon. If you check out all the lottery freeware, you will find many more ideas fully developed.

Easier to work with data?

SergeM,

  How about some specific software or info to help him along his path. His methods may not be yours or mine, but help, not shortcomings, is what he asked for. *S* We all had to start somewhere.