Need Help-

  • Thread starter Thread starter jamalsbro
  • Start date Start date
J

jamalsbro

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
 
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.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)




<[email protected]>
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
 
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.
--
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
 
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.
 
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.








- Show quoted text -
Click to expand...

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.
 
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.
Click to expand...

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.
 
Back
Top