I'm trying to get the 20 most frequent pairs(2/2) and triplets(3/3) of numbers, my table looks like this:
Imagine that there is a lottery with 10 drawn numbers out of 80 and in the table are the results.
I want a way to find the most drawn pairs and triplets from any numbers of draws.
Pairs of numbers(two numbers that have been drawn toghether):
-the numbers 1 and 3 have been drawn together 3 times, which makes it the most drawn pair of numbers out of the 3 draws.
-the numbers 1 and 80 have been drawn together 2 times along with 3,80 which also has been drawn 2 times out of 3 draws.
As for most drawn triplets( any combination of 3 numbers):
-1,3,80 is the most common triplet, being drawn together 2 times out of the 3 draws.