Hi edymurph, below are some of the ideas I’ve been working on as well as the spreadsheet attachments. I’ve also attached an updated version of the 1650-1846 inverse power 2 Edymurph.xls sheet that has some moving average tests in it (that I wrote about last post), along with adding the draws for 1639-1650.
Also I’ve attached a sheet for calculating the moving average of 7 on the decimal data by it’s individual number running down the column.
This is quite a long post so you may want to read each section one at a time to understand what it means from the spreadsheet it’s referring to.
Ticket Index Skip/Hit SheetOn the sheet IF-Stats-P1-P8- DECIMAL LF.xls I modified this sheet for the decimal series on Lotofacil. This sheet was originally posted by Red Devil in 2010 on this forum post
http://www.expertlotto.com/en/forum/vie ... f=9&t=1365 and was designed for the UK Lotto to analyse it’s ticket index positions down each column.
This sheet shows how often each digit between 0-9 hit in the yellow box, what the average hit is (which is the total hit (in the box above) divided by the cell AE1 which is 208 (draws). And also what the total skip is for each digit (how long it has been out). These should give some useful statistics to know.
In the purple section, this gives a percentage figure calculation, for how due the digit was when it was drawn (a skip divided by hit average) I think this is meant to be read as a percentage figure, so 0.2 would mean 20% etc.
This sheet also has filter drop down boxes where you can sort for certain items, for example, you can search how many draws in the position 8 column were 0.2 also.
In the Orange section, you can search for & see the pattern of when a certain number has hit. For example, over positions 7 & 8, you could see how often #4 has hit (from the drop down box) & it would show you the draw numbers when it appeared, then you could click “(All)” at the top to bring it back to the original data. You could do this on any of the numbers between 0-9 in each of their position columns.
Ticket Index ColumnsIn the UK Lotto (or even Demo 6/49) ticket index positions, you’d probably need to analyse positions 8 down to perhaps 2 or 3. (There are statistics that can also be seen in Expert Lotto under Winning Numbers, Analyze, selecting all draws (or a shorter latest amount), and then select Ticket Index Positions, under the basic folder)
With the Lotofacil decimal series, you’re mainly trying to predict the last 2 decimal positions. The last digit in the decimal series is Ticket Index Position 8, the second last digit is Ticket Index Position 7 in the IF-Stats-P1-P8- DECIMAL LF.xls spreadsheet.
The ticket Index Position 6 for this Lotofacil decimal series tends to stay constant for a while, but then it can change (eg from 3 to 4, 4 to 3, 3 to 2 or 2 to 1) When this is likely to happen, you’d need a prediction or calculation method to know when this is logically likely to occur. To use the moving average of 7, this may not help for this position (although it is useful for positions seven & eight).
The moving average of 7 (or even 14 or 21) is about 73% accurate in predicting if the next digit in the position is likely to go up or down from it’s last (on positions seven & eight)
Analysing the counted outcome in a sample of dataIn the sheet, Lotofacil Decimal- Index Analysis.xls, I’ve pasted the 2 columns from position 8 to position 7 all down one column. There are about 413 entries over these 2 columns. The formulas next to them calculate the sequence order in which they arrived. These were then sorted on the right into columns, that make a series of (for example) what 5 previous numbers were before the number at the end. (The final number is the one after the hyphen).
Then it is what 4 previous numbers were before the number after the hyphen. What 3 previous numbers were before the number after the hyphen. What 2 previous numbers were before the number after the hyphen, and finally, what was the previous 1 number before the one with the hyphen.
From my initial analysis, I was looking for if it was a sequence of say 7, 6, then 3, after this specific sequence (7,6,3) what was the count of all numbers that came after it. And then would it be wise to predict the number that had the highest count out of the statistics for the sequence 7,6,3.
You could also just look at the last 2 digits ( 6, 3) then what individual digit had the highest count afterwards for following this sequence.
Counting Sorted DataTo count a specific sample of data, you’d go down (for example) the 3 numbers sequence column (under sorted data) and start at the top of 763-0, copy all of these entries until the data ends at the start of 764-0. Then copy these into column B on the sheet called “countif” and then you’d see the total count of all the digits between 0-9. (To do this on the last 2 digits of 6,3, you’d copy all the data from the 2 number sequence column starting from 63-0 and ending with the last entry of 63-9).
Remember to clear all the contents of column B once you’re finished or it will mess up future counts if there is data still in column B of the countif sheet.
This can also be done on the 2 number sequence column, eg copy all the 6,3 data, or the 1 number sequence column eg all the number 3 data. (as well as the 4 & 5 number sequence columns, but the higher the number, the easier it is to just count it in it’s sorted excel columns. The smaller sequences like 1 have a lot of data so the countif sheet is there to make it easier.)
Demo Lotto 6/49 Ticket Index TestsI originally tested this idea on the Demo Lotto ticket index positions from 8 down to 3 that gave about 5700 records over 962 draws, pasted down the one column (also I have a sheet from position 8 down to position 2 about 6300 records) from this sample size of about 5700 records, it seemed to have enough data to show what patterns may emerge as the highest hitting numbers that come next.
(This Demo Lotto sheet is attached below in 5 rar archive files as it was 6 mb originally)
From what I’ve seen so far on the Demo Lotto ticket index position’s data, if you look at the last 2 digits, eg they were 6 and 3. Copy all the 1 number sequence data for 6 into the countif sheet (eg starting at 6-0 & ending at 6-9). Note down the top hitting number & then note down the second choice. Do the same for all the 1 number sequence data for 3 (eg starting at 3-0 & ending at 3-9).
So for instance #6 top counted number was 7, then second highest was 0
#3 top counted number was 3, then second highest was 4
In this case 7 was next (at row 91 column B on the demo 6/49 data) If the second or first choices had both been the same number, it may be wise to choose that number.
It would seem that 1st position top hit has precedence over second, but if the two second numbers show up twice over the first top hit numbers, you may be wiser to choose that number that showed up twice.
To use 8 and 3 (at rows 15,16,17 column B on the demo 6/49 data)
#8 top counted number was 9, then second highest was 4
#3 top counted number was 3, then second highest was 4
Since 4 showed up twice, it would seem the best number to choose. And the answer was 4 at line 17 in the data.
So far this is what I’ve seen in the Demo Lotto ticket index position’s data that has 5700 records and seems a good sample size to look at patterns.
Lotofacil Decimal AnalysisTo use the numbers (6,3) in the Lotofacil decimal data, there are only 3 entries in the 2 sequence column in this sample size of 413. So looking in the 2 sequence column under sorted values, it has 63-3, 63-4 and 63-4. It would seem 4 is the best choice.
The Lotofacil data has about 413 records so it doesn’t have as much data as the Demo 6/49 Lotto, but I’m looking into the idea of the last 2 digits counted for their top number first hit and second number hit (second choice could also be tied with two numbers, as could first choice (like 4&9 below). This would be ok if it is 2-3 numbers instead of just 2 for the sequence number that’s analysed (eg 6 or 3))
To use (6,3) again on Lotofacil, #6 had 7 as first choice, 5 as second choice.
#3 had 4 & 9 as first choice, 5 as second choice. In this example, 5 seems like the best choice for the next number.
From the 2 sequence column 4 seemed the best choice, from the 1 sequence columns, 5 seemed the best choice. Both 4&5 are near each other & not far apart like 9 & 0 are.
Out of the 3 entries for (6,3) 4 was the answer twice and 3 was the answer once (63-3, 63-4 and 63-4).
Reading #3 on it's own, it had 4 & 9 as first choice, to read (6,3) together, it showed 4 as the best 1st choice.
Thanks
You do not have the required permissions to view the files attached to this post.