Need Help-

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jamalsbro@gmail.com - 27 Mar 2008 02:28 GMT

Hi to all,

Thank you to everyone who helped me with the jam I was in last
time. Here is a little project I came up with during a bout of
insomnia this last week. I know it is hardly original, but I like the
idea and want to try it. I want (have) to create a spreadsheet to
track current lottery numbers here in my state. We have several but
the one I am starting with is a 4 number, with #'s from 0-9. What I
am doing is tracking all of the numbers using each number in its own
column. Then I am tracking the number of instances in which a
particular digit shows up and then using that to figure out what the
probability is of the next set of numbers to be. I hope I explained
it right. Basicly I want to use Excel to track the daily numbers,
treat each number as a single digit and based on how many times a
digit appears the more likely it is that that will come up again. The
question.. Is there a function in Excel that I can use to automate the
process of ifguring out the probability?

Thank you so much!

JMSSS

Reply to this Message

Jim Cone - 27 Mar 2008 02:45 GMT

Don't bother, the probability of a number being drawn does not
depend on what numbers were drawn in the past.
The probability last week, this week and next week is the same.
Also, some states (California and ?) provide a download
of past winning numbers from their website. California provides
a .txt file, but it can be opened by Excel.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)

<jamalsbro@gmail.com>
wrote in message
Hi to all,
Thank you to everyone who helped me with the jam I was in last
time. Here is a little project I came up with during a bout of
insomnia this last week. I know it is hardly original, but I like the
idea and want to try it. I want (have) to create a spreadsheet to
track current lottery numbers here in my state. We have several but
the one I am starting with is a 4 number, with #'s from 0-9. What I
am doing is tracking all of the numbers using each number in its own
column. Then I am tracking the number of instances in which a
particular digit shows up and then using that to figure out what the
probability is of the next set of numbers to be. I hope I explained
it right. Basicly I want to use Excel to track the daily numbers,
treat each number as a single digit and based on how many times a
digit appears the more likely it is that that will come up again. The
question.. Is there a function in Excel that I can use to automate the
process of ifguring out the probability?

Thank you so much!

JMSSS

Reply to this Message

Jim Cone - 27 Mar 2008 02:58 GMT

For instance, the following is my compilation of all of the
"mega" numbers drawn over the last 8 years in California.
Numbers 20 (most frequent) and 25 (least frequent) have
equal chances of being drawn tonight.

Signature

Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)
'-----------------
Nums Count
20 44
10 40
9 38
18 36
23 34
5 33
11 33
15 33
22 33
26 33
13 32
2 29
6 29
12 29
16 29
17 29
27 29
4 28
19 28
1 27
14 26
24 26
8 25
21 25
3 23
7 23
25 20
XL Companion Rel 2.76 - 03/26/08

Reply to this Message

Bob I - 27 Mar 2008 18:04 GMT

Don't waste your time, each weekly drawing is a completely unrelated
event, and the outcome of last week has absolutely no effect on the
drawing this week.

> Hi to all,
>
[quoted text clipped - 17 lines]
>
> JMSSS

Reply to this Message

jamalsbro@gmail.com - 28 Mar 2008 02:15 GMT

> Don't waste your time, each weekly drawing is a completely unrelated
> event, and the outcome of last week has absolutely no effect on the
[quoted text clipped - 24 lines]
>
> - Show quoted text -

I disagree- There are certain numbers that will have a tendancy to
come up. I understand that there is no science behind it, but one can
prove is that certain numbers will come up more than others and that
those numbers are more worth taking a chance on than others. Now,
keep in mind I am playing with a 4 number lottery game that really
doesnt pay out that high (top end maybe, maybe $7K), but is
interesting to try to hit it. I just wanted to see if there was a
better way to automate the process. My theory is that I can come
pretty close to picking an all 4 any order combo using my "system"
which I know is less than original.

Reply to this Message

Bob I - 28 Mar 2008 14:00 GMT

>>Don't waste your time, each weekly drawing is a completely unrelated
>>event, and the outcome of last week has absolutely no effect on the
[quoted text clipped - 36 lines]
> pretty close to picking an all 4 any order combo using my "system"
> which I know is less than original.

IF you were correct, the game is rigged, AND somebody is going to be in
deep trouble. IF the game is not rigged, then you can't prove anything.
In any short run of number picking, you will have some numbers "appear"
more than others, BUT that is only random chance, and if, you did
multiple sets, different numbers in each set will be the "high count"
group.

Reply to this Message

Rate this thread: