Positional Analysis for Odds & Evens

PAB

Member
Positional Analysis for Odds & Evens

I thought a Nice Little Exercise to do would be to Produce the Data for the Odds & Evens Distribution Per Position.
Using Revised Data from my Positional Number Distribution Table ( in Excel ) I have Created the Following. This Table Shows the Total Combinations Achievable if the Ball Number Drawn in EACH Position is an Odd OR Even ( After Numerical Sorting ) Number.

Position 1 Odd = 7,443,260 Position 1 Even = 6,540,556
Position 2 Odd = 6,967,620 Position 2 Even = 7,016,196
Position 3 Odd = 6,992,920 Position 3 Even = 6,990,896
Position 4 Odd = 6,993,910 Position 4 Even = 6,990,896
Position 5 Odd = 6,967,620 Position 5 Even = 7,016,196
Position 6 Odd = 7,443,260 Position 6 Even = 6,540,556

I then Applied this Concept to the Canadian 649 Lotto as at Draw 2,217 ( the 20th of April 2005 ) and came up with the following Table.
The Table is Set Out with the Position Number ( Odd ), the Expected Drawn to Date, the Actual Drawn to Date & the Difference +/- Between the Two. Then EXACTLY the Same for Even.

Canadian 649 Lotto

Position 1 Odd = 1180.06 1195 +14.94 Position 1 Even = 1036.94 1022 -14.94
Position 2 Odd = 1104.65 1105 +0.35 Position 2 Even = 1112.35 1112 -0.35
Position 3 Odd = 1108.66 1106 -2.66 Position 3 Even = 1108.34 1111 +2.66
Position 4 Odd = 1108.82 1093 -15.82 Position 4 Even = 1108.34 1124 +15.66
Position 5 Odd = 1104.65 1096 -8.65 Position 5 Even = 1112.35 1121 +8.65
Position 6 Odd = 1180.06 1222 +41.94 Position 6 Even = 1036.94 995 -41.94

I then Applied EXACTLY the Same to the UK Main 649 Lotto as at Draw 973 ( the 20th of April 2005 ) and came up with the following Table.

UK Main 649 Lotto

Position 1 Odd = 517.91 512 -5.91 Position 1 Even = 455.09 461 +5.91
Position 2 Odd = 484.81 484 -0.81 Position 2 Even = 488.19 489 +0.81
Position 3 Odd = 486.57 509 +22.43 Position 3 Even = 486.43 464 -22.43
Position 4 Odd = 486.64 493 +6.36 Position 4 Even = 486.43 480 -6.43
Position 5 Odd = 484.81 476 -8.81 Position 5 Even = 488.19 497 +8.81
Position 6 Odd = 517.91 506 -11.91 Position 6 Even = 455.09 467 +11.91

Now if we Only Knew ( in the Next Draw for Example ) if the Number in Position One ( After Numerical Sorting ) was Going to be Odd OR Even, we would then in Theory ONLY be Playing with 7,443,260 Combinations if it is Odd, Or 6,540,556 Combinations if it is Even, a LOT Less than the FULL 13,983,816 Combinations.
I think that this is Probably a High Profile Filter that could be Used Front End ( at the Top Or Near the Top of Filters Being Applied ), Especially with it Being Based on Almost a 50/50 Chance of the First Number ( After Numerical Sorting ) Either Being Odd Or Even. This will Reduce the Combinations by 46.77% if the First Number is Odd, and 53.22% if the First Number is Even.
Obviously I have just Used Position One as an Example, it is Quite Easy to Associate the Data for the Other Five Positions.
The Bottom Line is, you Need to have a Really Good Feeling for Odd Or Even in Order to Even Consider this as a Viable Proposition. But Reducing the Combinations to this Degree, and then Applying Any Other Filters that you Use, you should be Left with a More Manageable List of Combinations, Hopefully Still Including the JACKPOT Combination.
I just thought I would Throw this out for Discussion.

I Double Checked my Figure for Position One ( if it was Even ) with the Macro Below. It takes About 15 Seconds to Run.

Option Explicit
Option Base 1

Dim A As Integer
Dim B As Integer
Dim C As Integer
Dim D As Integer
Dim E As Integer
Dim F As Integer

Sub PositionOne()
Dim nCount As Long

Application.ScreenUpdating = False

nCount = 0

For A = 1 To 44
For B = A + 1 To 45
For C = B + 1 To 46
For D = C + 1 To 47
For E = D + 1 To 48
For F = E + 1 To 49

If PositionOneIsEven Then
nCount = nCount + 1
End If

Next F
Next E
Next D
Next C
Next B
Next A

ActiveCell.Value = nCount

Application.ScreenUpdating = True
End Sub

Private Function PositionOneIsEven() As Long
PositionOneIsEven = False
Select Case A
Case 2, 4, 6, 8, 10, 12, 14, 16, 18, 20, 22, 24, _
26, 28, 30, 32, 34, 36, 38, 40, 42, 44, 46, 48
PositionOneIsEven = True
Exit Function
End Select
End Function

Good Luck Everyone.
All the Best.
PAB
:wavey:
 

johnph77

Member
Interesting post - my contribution:

6/49
A B C D E F Total
1 1712304 1712304
2 1533939 178365 1712304
3 1370754 326370 15180 1712304
4 1221759 446985 42570 990 1712304
5 1086008 543004 79464 3784 44 1712304
6 962598 617050 123410 9030 215 1 1712304
7 850668 671580 172200 17220 630 6 1712304
8 749398 708890 223860 28700 1435 21 1712304
9 658008 731120 276640 43680 2800 56 1712304
10 575757 740259 329004 62244 4914 126 1712304
11 501942 738150 379620 84360 7980 252 1712304
12 435897 726495 427350 109890 12210 462 1712304
13 376992 706860 471240 138600 17820 792 1712304
14 324632 680680 510510 170170 25025 1287 1712304
15 278256 649264 544544 204204 34034 2002 1712304
16 237336 613800 572880 240240 45045 3003 1712304
17 201376 575360 595200 277760 58240 4368 1712304
18 169911 534905 611320 316200 73780 6188 1712304
19 142506 493290 621180 354960 91800 8568 1712304
20 118755 451269 624834 393414 112404 11628 1712304
21 98280 409500 622440 430920 135660 15504 1712304
22 80730 368550 614250 466830 161595 20349 1712304
23 65780 328900 600600 500500 190190 26334 1712304
24 53130 290950 581900 531300 221375 33649 1712304
25 42504 255024 558624 558624 255024 42504 1712304
26 33649 221375 531300 581900 290950 53130 1712304
27 26334 190190 500500 600600 328900 65780 1712304
28 20349 161595 466830 614250 368550 80730 1712304
29 15504 135660 430920 622440 409500 98280 1712304
30 11628 112404 393414 624834 451269 118755 1712304
31 8568 91800 354960 621180 493290 142506 1712304
32 6188 73780 316200 611320 534905 169911 1712304
33 4368 58240 277760 595200 575360 201376 1712304
34 3003 45045 240240 572880 613800 237336 1712304
35 2002 34034 204204 544544 649264 278256 1712304
36 1287 25025 170170 510510 680680 324632 1712304
37 792 17820 138600 471240 706860 376992 1712304
38 462 12210 109890 427350 726495 435897 1712304
39 252 7980 84360 379620 738150 501942 1712304
40 126 4914 62244 329004 740259 575757 1712304
41 56 2800 43680 276640 731120 658008 1712304
42 21 1435 28700 223860 708890 749398 1712304
43 6 630 17220 172200 671580 850668 1712304
44 1 215 9030 123410 617050 962598 1712304
45 44 3784 79464 543004 1086008 1712304
46 990 42570 446985 1221759 1712304
47 15180 326370 1370754 1712304
48 178365 1533939 1712304
49 1712304 1712304
Total 13983816 13983816 13983816 13983816 13983816 13983816
Odds 7443260 6967620 6992920 6992920 6967620 7443260
Evens 6540556 7016196 6990896 6990896 7016196 6540556
 

PAB

Member
Thanks for the Reply johnph77,

Your Table Agrees Exactly with Mine ( in Excel ).
It is Always Nice Being Able to Check that the Data Being Used is Correct.

All the Best.
PAB
:wavey:
 

PAB

Member
Hi BlouBul,

bloubul said:
PAB,

How must the spreadsheet be set up to use your macro?.

BlouBul :cool:

The Spreadsheet and Macro are Two Different Entities.
The Spreadsheet I was Referring to was One that I Set Up ( in Excel ) to Calculate the Data for the Total Combinations which Included EACH Number in EACH Position for ALL Combinations in a 649 Lotto.
The Macro I Posted was Just a Brute Force Approach to Check My Figure for Position One ( if it was Even ).

All the Best.
PAB
:wavey:
 

Sidebar

Top