Excel
"I tried that but when I tried to find the number of 2 card subsets in a deck of 52 cards I got something like 1335. That can't be right, so am I missing something?"
The correct number for that one is 1,326, as Don Schlesinger pointed out, but I guess you feel "that can't be right" because it may seem like too high a number. If that is so, would you feel such a high number would be OK for 50-card subsets? I guess it would, given the "enormity" of a 50-cared subset. But please note the number of all possible combinations of 2 items out of a set of 20 items :
Items in subset # of Combinations
1 20
2 190
3 1,140
4 4,845
5 15,504
6 38,760
7 77,520
8 125,970
9 167,960
10 184,756
11 167,960
12 125,970
13 77,520
14 38,760
15 15,504
16 4,845
17 1,140
18 190
19 20
20 1
The figure peaks at 10, so when you choose 10 items each time in your subset, the number of all possible subsets out of a total of 20 items is the highest one. The figures around 10 are symmetrical, because the number of combinations with x items in each subset is the same as with 20-x items. (This is easy to visualize: take 1 item each time and you have 20 combinations for subsets of
1. Then take 1 item
out in order to have a subset of
19 items each time, and you get again 20 combinations.)
There is a function in the Excel program which allows you to obtain all these figures in a few seconds.
Choose f
x and then COMBIN.
--Cyrus
PS: In case you are interested, the "peak" number in the 52-card set occurs, as you might have guessed by now, when you choose 26 numbers in every "subset". The figure of all possible combinations is
a little above 495
trillion.