The casino I play live keno at will display the last 500 games results showing you which numbers were selected for each game. I'm able to provide the data for all the games but need some program to analyze the results so i can see a possible common trend. I want the program to do the following:
Tell me how many of the same numbers came up on each game. Example if I enter in 100 games, it would say numbers 1,3,4,7,55 were played in 35 of those games. So I would want it to show how many 4 spots, 5 spots, 6 spots, 7 spots, 8, spots, 9, spots, and 10 spots hit.
Also show the top 10 numbers indivdually came up, the most for the set number of games I specify.
I have the numbers in an Excel spreadsheet to import the data into the program.