Least picked Combination - Challenge

[kosteczki]

Yeah I am posting a lot hoping to get some brains going maybe getting some new ideas.

Ok here is the challenge, Find a combination of 6 numbers that has won the least amount of prizes since 649 has started here in Canada.
(maybe someone has software that has all ready done this but I have just been using a lotto database.)

Here is what I have so far

4 9 17 26 41 43
Has won
2+B / 6 - 4 Times
3 / 6 - 0 Times
4 / 6 - 0 Times
5 / 6 - 0 Times
6 / 6 - 0 Times
Last win November 17, 2004
Can anyone find, or know of any combinations that have won less???
Post some even if it's slightly more.

 

[Brad]

Re-check your history database

Even with a Lotto649 history which has not been updated since game 2238 (07/02/05) I show more prizes won than you indicate with 4 9 17 26 41 43 :


2+B/6 - 35 Times
__3/6 - 49 Times
__4/6 - 05 Times

Looks like your d-base has errors ...

 

[kosteczki]

Well this is interesting, I checked those numbers 3 times using the database at
http://www.lotterycanada.com/lottery/
and what I wrote down is what it showed me.

But now I check it and get something similar to what you have

4/6 - 3 times
3/6 - 48 times
2+B/6 - 4 times

this is kinda weird, as soon as you mentioned the difference it changed at that site.

Well I guess this is open to a lot more combinations that can be lower now.

 

[PAB]

Hi kosteczki,

Using Data Upto and Including Draw 2,238 ( Saturday the 2nd of July 2005 ), I have the Following Results for Combination 04 09 17 26 41 43 :-
0 Numbers Matched = 983 Times
1 Number Matched = 896 Times
2 Numbers Matched = 268 Times
2 Numbers + Bonus Matched = 37 Times
3 Numbers Matched = 49 Times
4 Numbers Matched = 05 Times
Total Draws = 2,238

Hope this Helps.
All the Best.
PAB

 

[PAB]

Just as a Follow Up.
I have the Following ( Rightly Or Wrongly ) 37 Draws ( as at Draw 2,238 Being Saturday the 2nd of July 2005 ) that Match 2 Numbers + the Bonus Number for the Combination 04 09 17 26 41 43 :-

Draw 12 Date 28/08/1982 Numbers 11 17 19 20 36 43 Bonus 09
Draw 43 Date 02/04/1983 Numbers 04 10 23 38 41 46 Bonus 43
Draw 56 Date 02/07/1983 Numbers 05 09 27 39 40 43 Bonus 17
Draw 167 Date 17/08/1985 Numbers 04 21 32 38 43 45 Bonus 41
Draw 208 Date 18/01/1986 Numbers 11 17 23 26 30 34 Bonus 04
Draw 234 Date 19/04/1986 Numbers 07 17 26 28 42 48 Bonus 43
Draw 484 Date 10/09/1988 Numbers 04 16 17 18 22 44 Bonus 41
Draw 528 Date 11/02/1989 Numbers 06 09 11 17 20 27 Bonus 43
Draw 566 Date 24/06/1989 Numbers 06 10 18 26 27 41 Bonus 04
Draw 567 Date 28/06/1989 Numbers 02 04 13 16 17 40 Bonus 41
Draw 590 Date 16/09/1989 Numbers 04 06 11 17 27 44 Bonus 41
Draw 699 Date 03/10/1990 Numbers 17 20 36 40 43 47 Bonus 26
Draw 765 Date 22/05/1991 Numbers 16 26 30 33 43 49 Bonus 17
Draw 780 Date 13/07/1991 Numbers 03 09 24 26 33 47 Bonus 04
Draw 781 Date 17/07/1991 Numbers 02 08 09 20 23 43 Bonus 04
Draw 877 Date 17/06/1992 Numbers 09 12 17 25 30 35 Bonus 04
Draw 968 Date 01/05/1993 Numbers 04 18 39 40 42 43 Bonus 17
Draw 1224 Date 14/10/1995 Numbers 09 17 29 38 39 42 Bonus 04
Draw 1251 Date 17/01/1996 Numbers 01 09 27 33 37 41 Bonus 26
Draw 1371 Date 12/03/1997 Numbers 12 16 25 26 28 41 Bonus 43
Draw 1531 Date 23/09/1998 Numbers 01 13 26 28 29 41 Bonus 43
Draw 1539 Date 21/10/1998 Numbers 04 08 15 30 41 45 Bonus 26
Draw 1605 Date 09/06/1999 Numbers 09 12 22 26 29 32 Bonus 04
Draw 1628 Date 28/08/1999 Numbers 17 26 36 39 44 47 Bonus 04
Draw 1647 Date 03/11/1999 Numbers 05 26 30 34 41 44 Bonus 04
Draw 1664 Date 01/01/2000 Numbers 02 34 36 41 43 45 Bonus 04
Draw 1712 Date 17/06/2000 Numbers 05 07 09 33 41 48 Bonus 43
Draw 1721 Date 19/07/2000 Numbers 15 17 32 42 43 45 Bonus 09
Draw 1768 Date 30/12/2000 Numbers 07 09 17 27 31 48 Bonus 41
Draw 1860 Date 17/11/2001 Numbers 04 15 21 31 41 49 Bonus 43
Draw 1872 Date 29/12/2001 Numbers 25 26 34 36 43 46 Bonus 09
Draw 1894 Date 16/03/2002 Numbers 02 17 24 26 35 47 Bonus 41
Draw 1911 Date 15/05/2002 Numbers 01 04 14 20 41 44 Bonus 09
Draw 2135 Date 07/07/2004 Numbers 02 07 26 35 39 43 Bonus 17
Draw 2143 Date 04/08/2004 Numbers 06 07 09 11 30 43 Bonus 04
Draw 2168 Date 30/10/2004 Numbers 18 26 29 39 43 45 Bonus 09
Draw 2173 Date 17/11/2004 Numbers 13 24 30 41 43 47 Bonus 17

I am Sure Someone will Correct me if I am Wrong.
Hope this Helps.
All the Best.
PAB

 

[kosteczki]

Thx guys, wish I was not wrong but hey.
Anyways. PAB are you using an excel database or some software.
If using software do you have a way to list combinations that have been the least picked. I just have some things I want to experiment with.

 

[PAB]

Hi kosteczki,

I have an Excel Database I Use Containing ALL the Draws.
For this Instance I Used Formulas to Work Out the Matches for the Combination you Stated.
There are of Course, as at Draw 2,252 ( Saturday the 20th of August 2005 ), Still 13,981,564 Combinations Yet to be Drawn.
Could you give us a Little More Information by what you Mean when you Say Combinations that have Been the Least Picked Please. Also, are the Experiments that you want to Perform on these Combinations to do with Applying Different Filters Or Something.

All the Best.
PAB

 

[kosteczki]

As soon as I have completed entering my database in an excel sheet I was going to start checking to see what the previous results where of combinations drawn.

For example last winning combo only had 4/6 as the highest previous payout. Hopefully eliminating combinations that have had higher and more payouts would help in shortening the amount of choices I have for combinations being used.

HOPEFULLY heh

To add to this I would also be choosing combinations that have had very little prize payouts as combinations to keep in future eliminations.

BTW how did you get those results in excel..what formula did you use?

 

[PAB]

Hi kosteczki,

BTW how did you get those results in excel...what formula did you use?

Assuming that your 6 Main Drawn Numbers are in Cells "E6:J6", and the Bonus Number is in Cell "K6" for Example.
Insert the Combination you want to Check in Cells "M4:R4".
Copy & Paste the Following Formula into Cell "M6".
Copy the Formula Down as Far as Needed.

The Formula is :-
=IF(SUMPRODUCT(COUNTIF($M$4:$R$4,$E6:$J6))=2,IF(SUMPRODUCT(COUNTIF($M$4:$R$4,$K6))=1,"2+","2"),SUMPRODUCT(COUNTIF($M$4:$R$4,$E6:$J6)))

Hope this Helps.
All the Best.
PAB

 

[Brad]

As soon as I have completed entering my database in an excel sheet <<snip>> ...

I don't know how good the database at LotteryCanada is cuz I've never used it bfr. Many players here go to BCLC.com which is deemed to have a very accurate record of all draws, available for download from their site in a CSV format. See HERE , near bottom of page.

The numbers I posted earlier were obtained using Gail Howard's prog, which does occasionally have 1 or 2 typos (until I e-mail Joe with the correct info, LOL) ... this may explain my 2+B/6 discrepancy vs PAB's stats. Therefore I would accept PAB's as more correct .

Now regarding the quick stats change at LotteryCanada ... maybe they read this BB?

Cheers


PS I do not actively indulge in Lotto649, however I do update my stats for it every so often ...

 

[kosteczki]

Thx Brad I have been entering all the draws into an excell sheet from the printed version I got from the lotto corp. This has saved me soo much time.

Thx for the formula PAB, I changed them a bit to suit my needs and they still worked.

You wouldn't happen to know how I can calculate the occurance of let's say the digit 1 in cells I2 - I2252, then I would see the occurance of the digit 2, 3, 4, 5

anyways thx again

 

[PAB]

Hi kosteczki ,

I am Glad the Previous Formula Achieved the Results you Wanted.
As Far as …

You wouldn't happen to know how I can calculate the occurrence of let's say the digit 1 in cells I2 - I2252, then I would see the occurrence of the digit 2, 3, 4

… is Concerned, the Formulas Below ( Change Accordingly ) will give you the Total Matched Occurrences of 0, 1, 2, 2+, 3, 4, 5, & 6.

Here they are :-

=COUNTIF(I$2:I$2252,0)
=COUNTIF(I$2:I$2252,1)
=COUNTIF(I$2:I$2252,2)
=COUNTIF(I$2:I$2252,"2+")
=COUNTIF(I$2:I$2252,3)
=COUNTIF(I$2:I$2252,4)
=COUNTIF(I$2:I$2252,5)
=COUNTIF(I$2:I$2252,6)

You will Probably Need to Use an End Range in Excess of 2252 to Allow for the Entry of Future Draws.

Hope this Helps.
All the Best.
PAB

 

[kosteczki]

I feel dumb, I figured out that formula right after asking for it, but I went to bed instead of replying to you to forget about it.

Anyways as for entering the larger range as long as you right click and INSERT a row pusing the cells down, the formula automatically adjusts to include the new row.

Thank you PAB

 

[PAB]

Hi kosteczki,

I feel dumb, I figured out that formula right after asking for it, but I went to bed instead of replying to you to forget about it.

Not at All, Been there, Done it & got the T-Shirt. Tiredness has a Weird Effect on Natural Logical Thinking.

Anyways as for entering the larger range as long as you right click and INSERT a row pushing the cells down, the formula automatically adjusts to include the new row.

Exactly Correct. I did Not Know how Conversant you were with Excel, so I did Not want to Complicate things.

Glad Everything is going According to Plan.

All the Best.
PAB

 

[kosteczki]

Thank you.
I do work with excell on quite a regular basis at work, but 99% of the time I am repeating formulas I figured out months ago, so it takes a while to get the hang of new ones.
But I should be good now..at least for this part of my experiment.