Add a third column that accumulates the percentagies

35 1.90 .019
13 4.80 .067
25 4.80 .115

You can then use index and match to pick a number.

the challenge will be picking 9 numbers that are not redundant.

You have an additional challenge in that your numbers add up to greater than
500%

They should add to 100%.

--
Regards,
Tom Ogilvy


"Timothy Consolo" wrote in
message ...
Here is what i have so far. What I need to do is come up with a number
gererator that will spit out a set of numbers based on each number's
statistical frequency of past appearance.

Total Number of Drawings: 104

First 5 numbers % of each number's fequency of draw over 104 drawings

35=1.90%
13=4.80%
25=4.80%
30=5.80%
38=5.80%
4=6.70%
11=6.70%
18=6.70%
24=6.70%
45=6.70%
46=6.70%
9=7.70%
12=7.70%
17=7.70%
19=7.70%
23=7.70%
33=7.70%
36=7.70%
41=7.70%
3=8.70%
21=8.70%
34=8.70%
42=8.70%
43=8.70%
44=8.70%
7=9.60%
22=9.60%
27=9.60%
29=9.60%
1=10.60%
5=10.60%
8=10.60%
14=10.60%
15=10.60%
37=10.60%
39=10.60%
47=10.60%
48=10.60%
50=10.60%
52=10.60%
6=12.50%
32=12.50%
40=12.50%
49=12.50%
2=13.50%
28=13.50%
20=14.40%
31=14.40%
16=15.40%
26=15.40%
51=15.40%
10=16.30%

Mega Ball same perameters as mentioned above

2=0.00%
9=0.00%
16=0.00%
19=0.00%
30=0.00%
41=0.00%
45=0.00%
49=0.00%
51=0.00%
4=1.00%
11=1.00%
12=1.00%
13=1.00%
17=1.00%
23=1.00%
25=1.00%
28=1.00%
36=1.00%
40=1.00%
42=1.00%
44=1.00%
47=1.00%
50=1.00%
6=1.90%
14=1.90%
15=1.90%
20=1.90%
24=1.90%
26=1.90%
27=1.90%
31=1.90%
37=1.90%
38=1.90%
46=1.90%
48=1.90%
1=2.90%
7=2.90%
18=2.90%
29=2.90%
32=2.90%
33=2.90%
39=2.90%
43=2.90%
5=3.80%
10=3.80%
22=3.80%
35=3.80%
52=3.80%
8=4.80%
21=4.80%
34=4.80%
3=6.70%




------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/