To detect the pair in pick 3 with the highest and lowest digits. Pairs with identical digits, e.g., 544, are not included in the study. We have ten identical pairs: 00, 11, 22, 33, 44, 55, 66, 77, 88, 99, which are not included in the study. Objective: to identify which of the three pairs in positions 1, 2, 1, 3, 2, 3 has the highest and lowest digits, e.g., 978 has the highest 9 and the lowest 7 in position 1, 2. https://www.mediafire.com/file/8bucax7uw9oe6mb/maior+e+menor.xlsx/file
To detect the pair in pick 3 with the highest and lowest digits.
- Thread starter jack
- Start date
The order within the positional pair doesn't matter if it's greater or lesser, e.g., 1, 2, 6, 3, or 3, 6. The objective is to find, in three options (1, 2, 1, 3, 2, 3), which pair has the largest and smallest digit of the pick3. For example, if I know that 8 is greater and 3 is lesser, I have 8, 7, 3; 8, 6, 3; 8, 5, 3; 8, 4, 3, 4 options. The result of the twin pair is not included in the study.
Frank
Member
Helper columns E and F were added to keep the formulas manageable as the order of digits in the pairs were sometimes not in order, eg sometimes 1.6 other times 6.1 and the formulas had to deal with this.
https://www.mediafire.com/file/f3qv7c126fl1yxc/maior+e+menor.xlsx/file
https://www.mediafire.com/file/f3qv7c126fl1yxc/maior+e+menor.xlsx/file
Hello, sorry, I forgot to mention that to see the quantity of each larger x smaller pair, below we have the 45 larger and smaller pairs, see frequencies and delays = list 45
0,1
0,2
0,3
0,4
0,5
0,6
0,7
0,8
0,9
1,2
1,3
1,4
1,5
1,6
1,7
1,8
1,9
2,3
2,4
2,5
2,6
2,7
2,8
2,9
3,4
3,5
3,6
3,7
3,8
3,9
4,5
4,6
4,7
4,8
4,9
5,6
5,7
5,8
5,9
6,7
6,8
6,9
7,8
7,9
8,9
0,1
0,2
0,3
0,4
0,5
0,6
0,7
0,8
0,9
1,2
1,3
1,4
1,5
1,6
1,7
1,8
1,9
2,3
2,4
2,5
2,6
2,7
2,8
2,9
3,4
3,5
3,6
3,7
3,8
3,9
4,5
4,6
4,7
4,8
4,9
5,6
5,7
5,8
5,9
6,7
6,8
6,9
7,8
7,9
8,9
Frank
Member
Unfortunately you have changed the rules by wanting to count pairs in ascending order only. In your spreadsheet you had results like 4.0 and 1.9 as valid outputs, suggesting that wrongly ordered pairs were a valid outcome. Ive had to add both versions of order together to get the result you require. I dont think theres much point in listing delays for these events as they are so rare. For example the most prolific difference 5.0 ( or 0.5) in the table only happens 13 times which means it appears every 46 draws on average. Not much point doing the others is there?
I have done another table in cols AA to AD which plots pairs with the same difference, e.g 1.5, 2.6, 3.7 all with difference of 4, hence the higher counts in this table as it bundles a group of pairs with the same dfference in the same column. Most of them count in the range 20 to 30 appearances per 600 draws. So on average any of those can come up every 20 to 30 draws. Not a lot of help either in predicting the next triple.
You will note that there are no pairs with a difference of 1 as they get eliminated when applying your rules, e.g 1,2,3 shows up only as 1.3 - a difference of 2. Triple 1,1,2 is a No from the word go, according to your rules..
This concludes my work on this project. The new sheet has the same link as before.
I have done another table in cols AA to AD which plots pairs with the same difference, e.g 1.5, 2.6, 3.7 all with difference of 4, hence the higher counts in this table as it bundles a group of pairs with the same dfference in the same column. Most of them count in the range 20 to 30 appearances per 600 draws. So on average any of those can come up every 20 to 30 draws. Not a lot of help either in predicting the next triple.
You will note that there are no pairs with a difference of 1 as they get eliminated when applying your rules, e.g 1,2,3 shows up only as 1.3 - a difference of 2. Triple 1,1,2 is a No from the word go, according to your rules..
This concludes my work on this project. The new sheet has the same link as before.
Okay Frank, you're correct. The objective is to see the larger and smaller pair moving through the 3 positions. 1, 2, 1, 3, 2, 4, with the third digit being the single digit or the triplet of the pick 3. For example, I know the pair is 4 and 8, so between them we have 5, 6, 7, that is, 458, 468, and 478. Only three options to play. When the smaller is 1 and the larger is 9, we have 2, 3, 4, 5, 6, 7, 8 = 7 games. How do you project the larger smaller pair with the draws, between cycles, delays, and repetitions? That's the way to go. Thank you, Frank.