How To Use VBA To Create A Moving Average Of Prime Numbers In Lotto Results
Identifying patterns in lotto results can be difficult but one pattern that is consistent is the frequency of prime numbers. Prime numbers should make up around 30% of all lotto results and this article introduces the idea of moving averages and how they might help improve your own lotto odds. A moving average is simply the average over a subset or period of data. It becomes a powerful tool when you consider subsequent averages which might indicate a move away or back to the mean. Prime Numbers And A Random Data Set The easiest way to test lotto ideas is to create your own random data set which should simulate a series of lotto results. You need to create a table of random results, Euromillions and calculate how many prime numbers are in each line. Then, we can write some VBA code to calculate the average to see if there are any patterns in the numbers. You should have a data table looking like this, where the final column is a count of how many primes are in each line. 18 19 26 29 30...