mardi 18 août 2015

Finding repeating patterns in data

I'm trying to use spreadsheet to find a pattern in a large list of numbers. This is for a lottery game that selects 12 numbers from 1-24. There is only one of each number. I would like to know what formula I need to use to find the most common pattern. When I say pattern, I am leaning towards finding the most common pattern of odd/even patterns. So 1, 4, 7, 10, 13.... is odd-even-odd-even-odd. Im also open to other ideas.

Example:
Winning Numbers
1 2 3 4 5 8 10 11 12 19 20 21

1 3 6 9 10 13 14 17 18 20 21 24

1 2 4 5 8 10 15 16 17 22 23 24

2 3 5 7 9 11 13 14 17 19 21 22

1 2 5 6 7 9 11 15 17 18 23 24

2 4 8 9 10 11 12 17 18 22 23 24

3 4 9 10 11 13 14 15 18 19 20 23

Aucun commentaire:

Enregistrer un commentaire