As my final project for my statistics class, I want to prove that using a combination of the most frequent drawn lottery numbers can lead to a better chance of winning the lottery (Hot Numbers method). Now, the sequence ranges from 0-50 with only 5 numbers drawn. I will not use all of the drawn numbers form 0-50, I will only use those numbers that are drawn more frequently than others. Does anybody now how I can create a random sequence of number combinations from these most frequent used numbers? Now, I know that the list will be huge given all of the possible random combinations possible. So, I need to narrow them down to 15 and I need them to be random and non repetitive. Like, I can draw 6 twice in the five numbers I am allowed to draw. I can get 6-11-25-33-45 or 6-25-33-35-45, etc. but not 6-6-33-35-45.
I tried doing so by generating random drawings but they are not sequences of combinations. They are random numbers from the highest picked numbers. For instance, I get, 34-5-16-49-1. I first filled in the numbers that are most drawn on table C; assigne them absolute random values on A and give the absolute values on B using this formula: =RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1.
Does anybody have a better way to generate random sequence of combinations, rather than random combinations?
I tried doing so by generating random drawings but they are not sequences of combinations. They are random numbers from the highest picked numbers. For instance, I get, 34-5-16-49-1. I first filled in the numbers that are most drawn on table C; assigne them absolute random values on A and give the absolute values on B using this formula: =RANK($A2,$A$2:$A$22)+COUNTIF(B$1:B1,B1)-1.
Does anybody have a better way to generate random sequence of combinations, rather than random combinations?
