Hi
I'm trying to see what would be the best way of determining the possible combinations for picking the winner of each group (groups A to H) in the upcoming soccer world cup.
There are a total of 4^8 = 65,536 combinations if you don't exclude any team, but if you limit it to say 2 selections per group, then the total number of combinations are 2^8 = 256 (a bit more reasonable to deal with).
Is there a way to show all the possible combinations in excel?
The groups are as follows:
<colgroup><col><col><col></colgroup><tbody>
</tbody>
If you selected every team as a possible winner:
<colgroup><col><col span="4"><col span="3"></colgroup><tbody>
</tbody>
But if you selected the following teams there are only 12 combinations:
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
I'm trying to see what would be the best way of determining the possible combinations for picking the winner of each group (groups A to H) in the upcoming soccer world cup.
There are a total of 4^8 = 65,536 combinations if you don't exclude any team, but if you limit it to say 2 selections per group, then the total number of combinations are 2^8 = 256 (a bit more reasonable to deal with).
Is there a way to show all the possible combinations in excel?
The groups are as follows:
Group | Team | Odds |
A | Brazil | $ 1.22 |
Mexico | $ 9.00 | |
Croatia | $ 9.00 | |
Cameroon | $ 21.00 | |
B | Spain | $ 1.83 |
Holland | $ 3.10 | |
Chile | $ 6.00 | |
Australia | $ 34.00 | |
C | Colombia | $ 1.72 |
Ivory Coast | $ 5.00 | |
Japan | $ 6.00 | |
Greece | $ 7.00 | |
D | Italy | $ 2.75 |
Uruguay | $ 2.88 | |
England | $ 3.10 | |
Costa Rica | $ 34.00 | |
E | France | $ 1.83 |
Switzerland | $ 3.50 | |
Ecuador | $ 5.00 | |
Honduras | $ 21.00 | |
F | Argentina | $ 1.22 |
Bosnia-Herzegovina | $ 8.00 | |
Nigeria | $ 10.00 | |
Iran | $ 34.00 | |
G | Germany | $ 1.53 |
Portugal | $ 3.75 | |
USA | $ 12.00 | |
Ghana | $ 13.00 | |
H | Belgium | $ 1.67 |
Russia | $ 3.20 | |
South Korea | $ 9.00 | |
Algeria | $ 23.00 |
<colgroup><col><col><col></colgroup><tbody>
</tbody>
If you selected every team as a possible winner:
Select Potential Winners | |||||||
1st Pick | 2nd Pick | 3rd Pick | 4th Pick | Combination 1 | |||
A | Brazil | Mexico | Croatia | Cameroon | Brazil | ||
B | Spain | Holland | Chile | Australia | Spain | ||
C | Colombia | Ivory Coast | Japan | Greece | Colombia | ||
D | Italy | Uruguay | England | Costa Rica | Italy | ||
E | France | Switzerland | Ecuador | Honduras | France | ||
F | Argentina | Bosnia-Herzegovina | Nigeria | Iran | Argentina | ||
G | Germany | Portugal | USA | Ghana | Germany | ||
H | Belgium | Russia | South Korea | Algeria | Belgium | ||
Number of combinations | 65536 | Multibet Odds | $ 60.24 |
<colgroup><col><col span="4"><col span="3"></colgroup><tbody>
</tbody>
But if you selected the following teams there are only 12 combinations:
Select Potential Winners | ||||
1st Pick | 2nd Pick | 3rd Pick | 4th Pick | |
A | Brazil | |||
B | Spain | Holland | ||
C | Colombia | |||
D | Italy | Uruguay | England | |
E | France | |||
F | Argentina | |||
G | Germany | Portugal | ||
H | Belgium | |||
Number of combinations | 12 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>