CT United States Member #60059 April 4, 2008 856 Posts Offline

Posted: February 26, 2013, 2:19 pm - IP Logged

Quote: Originally posted by SergeM on February 26, 2013

You can easily build a scam by testing on the past results and presenting frequent events as system. Of course when the wind is changing direction, that system stops working.

You've hit the nail on the head?

Now take that and build a system.

Luck be with you!!!

NOTE: All numbers posted are BOXED and unless otherwise noted.

Charlotte NC United States Member #17406 June 18, 2005 4053 Posts Offline

Posted: March 5, 2013, 12:36 am - IP Logged

Pick 3 and Pick 4 lottery has its own math; unlike math as we know it. It WRAPS and moves within its own realm. When you go outside the realm, it's like trying to solve a simple first grade addition and subtraction problem with geometry or calulus, or something else complicated and way off track etc. Proof - THE RUNDOWN!

Horwood NL Canada Member #70613 February 6, 2009 296 Posts Offline

Posted: March 18, 2013, 8:45 am - IP Logged

I would say number 1. Since it is so hard to pick the winners with our formulas, we should be trying to pick the losers with our software and then play the numbers it doesn't pick. Reverse thinking might be the way to look at the lottery.

New Hampshire United States Member #136492 December 12, 2012 322 Posts Offline

Posted: May 13, 2013, 7:56 pm - IP Logged

Hi players I have a powerball related math question. Can someone tell me how I would set up a formula to determine how many of the possible 5.1 million or so white ball combinations contain numbers that are all at least 5 numbers away from any other given number in that line. For example 1-6-11-16-21, 1-6-11-16-22, 2-7-12-17-22, and so on and so forth. Would appreciate any input!

United States Member #130795 July 25, 2012 80 Posts Offline

Posted: May 14, 2013, 2:20 am - IP Logged

Quote: Originally posted by msharkey2001 on May 13, 2013

Hi players I have a powerball related math question. Can someone tell me how I would set up a formula to determine how many of the possible 5.1 million or so white ball combinations contain numbers that are all at least 5 numbers away from any other given number in that line. For example 1-6-11-16-21, 1-6-11-16-22, 2-7-12-17-22, and so on and so forth. Would appreciate any input!

I cannot offer a math formula. But I can offer an algorithm, implemented in Excel VBA below.

But first, it might be useful to clear up a misunderstanding. The number of combinations -- COMBIN(59,5) -- is 5,006,386, about 5.01 million. I don't know if your "5.1 million or so" is a typo, or if you misunderstand how the odds are computed. The odds (probability) of matching 5, but not the powerball is about 1 in 5,153,632.65 because it is 34 in 175,223,510. That is, 1 in 35*COMBIN(59,5) / 34.

So the answer to your question is 962,598 of 5,006,386 combinations, about 19.23%.

That can be computed efficiently by the following Excel VBA code. It runs in less than 0.03 sec on my (ancient) computer.

Sub doit() Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long nc = WorksheetFunction.Combin(nNum, 5) n = 0 For i1 = 1 To nNum - 20 For i2 = i1 + 5 To nNum - 15 For i3 = i2 + 5 To nNum - 10 For i4 = i3 + 5 To nNum - 5 For i5 = i4 + 5 To nNum n = n + 1 Next i5, i4, i3, i2, i1 MsgBox Format(n, "#,##0") & " / " & _ Format(nc, "#,##0") & " " & _ Format(n / nc, "0.0000%") End Sub

If you do not trust that implementation, the following less-efficient algorithm exhaustively generates all COMBIN(59,5) combinations and counts those that meet your requirements. It runs in less than 0.8 sec on my computer.

Sub doit2() Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long n = 0: nc = 0 For i1 = 1 To nNum - 4 For i2 = i1 + 1 To nNum - 3 For i3 = i2 + 1 To nNum - 2 For i4 = i3 + 1 To nNum - 1 For i5 = i4 + 1 To nNum nc = nc + 1 If i5 >= i4 + 5 And i4 >= i3 + 5 And _ i3 >= i2 + 5 And i2 >= i1 + 5 Then n = n + 1 Next i5, i4, i3, i2, i1 MsgBox Format(n, "#,##0") & " / " & _ Format(nc, "#,##0") & " " & _ Format(n / nc, "0.0000%") End Sub

New Hampshire United States Member #136492 December 12, 2012 322 Posts Offline

Posted: May 14, 2013, 6:03 am - IP Logged

Quote: Originally posted by mathhead on May 14, 2013

I cannot offer a math formula. But I can offer an algorithm, implemented in Excel VBA below.

But first, it might be useful to clear up a misunderstanding. The number of combinations -- COMBIN(59,5) -- is 5,006,386, about 5.01 million. I don't know if your "5.1 million or so" is a typo, or if you misunderstand how the odds are computed. The odds (probability) of matching 5, but not the powerball is about 1 in 5,153,632.65 because it is 34 in 175,223,510. That is, 1 in 35*COMBIN(59,5) / 34.

So the answer to your question is 962,598 of 5,006,386 combinations, about 19.23%.

That can be computed efficiently by the following Excel VBA code. It runs in less than 0.03 sec on my (ancient) computer.

Sub doit() Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long nc = WorksheetFunction.Combin(nNum, 5) n = 0 For i1 = 1 To nNum - 20 For i2 = i1 + 5 To nNum - 15 For i3 = i2 + 5 To nNum - 10 For i4 = i3 + 5 To nNum - 5 For i5 = i4 + 5 To nNum n = n + 1 Next i5, i4, i3, i2, i1 MsgBox Format(n, "#,##0") & " / " & _ Format(nc, "#,##0") & " " & _ Format(n / nc, "0.0000%") End Sub

If you do not trust that implementation, the following less-efficient algorithm exhaustively generates all COMBIN(59,5) combinations and counts those that meet your requirements. It runs in less than 0.8 sec on my computer.

Sub doit2() Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long n = 0: nc = 0 For i1 = 1 To nNum - 4 For i2 = i1 + 1 To nNum - 3 For i3 = i2 + 1 To nNum - 2 For i4 = i3 + 1 To nNum - 1 For i5 = i4 + 1 To nNum nc = nc + 1 If i5 >= i4 + 5 And i4 >= i3 + 5 And _ i3 >= i2 + 5 And i2 >= i1 + 5 Then n = n + 1 Next i5, i4, i3, i2, i1 MsgBox Format(n, "#,##0") & " / " & _ Format(nc, "#,##0") & " " & _ Format(n / nc, "0.0000%") End Sub

Thanks mathhead for taking the time to do this. Very much appreciated on my part. Good luck to you on tomorrows drawing!

United States Member #130795 July 25, 2012 80 Posts Offline

Posted: May 14, 2013, 11:08 am - IP Logged

Quote: Originally posted by mathhead on May 14, 2013

I cannot offer a math formula. But I can offer an algorithm, implemented in Excel VBA below.

But first, it might be useful to clear up a misunderstanding. The number of combinations -- COMBIN(59,5) -- is 5,006,386, about 5.01 million. I don't know if your "5.1 million or so" is a typo, or if you misunderstand how the odds are computed. The odds (probability) of matching 5, but not the powerball is about 1 in 5,153,632.65 because it is 34 in 175,223,510. That is, 1 in 35*COMBIN(59,5) / 34.

So the answer to your question is 962,598 of 5,006,386 combinations, about 19.23%.

That can be computed efficiently by the following Excel VBA code. It runs in less than 0.03 sec on my (ancient) computer.

Sub doit() Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long nc = WorksheetFunction.Combin(nNum, 5) n = 0 For i1 = 1 To nNum - 20 For i2 = i1 + 5 To nNum - 15 For i3 = i2 + 5 To nNum - 10 For i4 = i3 + 5 To nNum - 5 For i5 = i4 + 5 To nNum n = n + 1 Next i5, i4, i3, i2, i1 MsgBox Format(n, "#,##0") & " / " & _ Format(nc, "#,##0") & " " & _ Format(n / nc, "0.0000%") End Sub

If you do not trust that implementation, the following less-efficient algorithm exhaustively generates all COMBIN(59,5) combinations and counts those that meet your requirements. It runs in less than 0.8 sec on my computer.

Sub doit2() Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long n = 0: nc = 0 For i1 = 1 To nNum - 4 For i2 = i1 + 1 To nNum - 3 For i3 = i2 + 1 To nNum - 2 For i4 = i3 + 1 To nNum - 1 For i5 = i4 + 1 To nNum nc = nc + 1 If i5 >= i4 + 5 And i4 >= i3 + 5 And _ i3 >= i2 + 5 And i2 >= i1 + 5 Then n = n + 1 Next i5, i4, i3, i2, i1 MsgBox Format(n, "#,##0") & " / " & _ Format(nc, "#,##0") & " " & _ Format(n / nc, "0.0000%") End Sub

A VBA function might be more useful. See below. You can call it as =gap5Combo() to get just the single count (962,598). Or you can select a range of up to 3 horizontal cells and array-enter the same formula (press ctrl+shift+Enter) to get up to 3 values: the count of qualifying combos (962,598), the count of all possible combos (5,006,386), and the fraction of qualifying combos (about 0.1923), which you can format as Percentage. You can also select a range of up to 3 vertical cells and array-enter the formula =TRANSPOSE(gap5Combo()).

Function gap5Combo() As Variant ' number of combinations where each number ' is 5 or more from any other number Const nNum As Long = 59 ' Powerball Dim i1 As Long, i2 As Long, i3 As Long Dim i4 As Long, i5 As Long Dim n As Long, nc As Long nc = WorksheetFunction.Combin(nNum, 5) n = 0 For i1 = 1 To nNum - 20 For i2 = i1 + 5 To nNum - 15 For i3 = i2 + 5 To nNum - 10 For i4 = i3 + 5 To nNum - 5 For i5 = i4 + 5 To nNum n = n + 1 Next i5, i4, i3, i2, i1 gap5Combo = Array(n, nc, n / nc) End Function