Quote: Originally posted by WIN D on November 30, 2003
Hyper....wish you would describe this some more ....sounds interesting.
ok, start off with your entire history in columns (1st ball, 2nd ball, 3rd ball)
beneath the list, I put the excel formula
=MODE(A2:A9100) ' for example... A2 because of the header row and 9100 represents the end of the history list
now just autofill left and you have the mode for each position. I keep the number side by side in 2 formats, one is each number in position (eg A2=5, B2=6, C2=1) then the D column is the resultant combo (561) for later filtering or testing. You will notew that the combo identified by the MODE is NOT the mode of the D column (simply autofill again to see that one where you put the mode formula).
next step is to employ the advanced filter, you want only results that contain the column 1 mode number (if it's 1 then all in the results will start with 1). Place this in columns F G H and I. THen run the mode formula again under the new columns. Column I contains the mode of the resultant combos. If this number is the same as the individual numbers in columns F thru H, stop and use that, if not, then find out whether the number in column 2 or 3 is more frequent... if column#2 mode is 5, then try
=COUNTIF(G2:G500, "=5") ' this assumes the resultant set is smaller, 500 is just for example
do the same for the mode number in the 3rd column, the one with the higher frequency wins, do another advanced format to columns K L M and O, this time only for drawings that contain the 1st number and Second number mode. This leaves you with the need to run the MODE again on the results to determine the last number.
In the end you are left with ONE number that represents the MOST Frequently drawn number in one position AND the most frequent numbers that are drawn with it. Of course you must repeat this for each of the original mode numbers (in their respective positions) and you end up with 3 picks.
At this point, you can do an auto-filter on the entire list of column D to look for those combos to get an idea of how many times they were drawn and (if you include 2 columns for draw# and date) how far apart they occur.
I have yet to finish this with the PA Daily number, but I had a massive cash 5 file that bore no good results. I'll be crunching the PA numbers sometime tomorrow after updating the draws for tonight. I'll post them before tomorrow's draw.
note that if any of the MODE numbers change, the end results need to be re-calculated. I did this with the Cash5 by hand, need to check the counts also using a countif for 1 thru 9 in each position. if 2 are the same, excel arbitrarily chooses one, but if 2 numbers are equal then you might want to generate a pick for each case.