Mathematics Savant Needed

chkmte

Flush
Joined
Apr 29, 2016
Messages
1,941
Reaction score
1,104
Location
MO
There are (21) consonants in the English alphabet. If sorting into groups of (13), how many possible groups exist? What is the formula to figure this out?
 

Davism72

Flush
Joined
Oct 21, 2018
Messages
1,547
Reaction score
1,809
Location
Reno, NV
1596570948069.png


Where n is the number of choices (21 consonants) and r is the group size (13). Order doesn't matter and repetition isn't allowed

The answer here is 203490.

https://www.mathsisfun.com/combinatorics/combinations-permutations-calculator.html
 

Coyote

4 of a Kind
Supporting Member
Joined
Jan 28, 2018
Messages
5,636
Reaction score
8,236
Location
Athens, Greece
Reminds me of a line I read at 14 in the Penthouse magazine (it must have been a typo) :rolleyes:
 

chkmte

Flush
Joined
Apr 29, 2016
Messages
1,941
Reaction score
1,104
Location
MO
Wow. Thanks for that prompt reply everyone.
 

chkmte

Flush
Joined
Apr 29, 2016
Messages
1,941
Reaction score
1,104
Location
MO
Now then, anyone here an excel guru? I got a hell of puzzle I'm trying to sort through. :)
 

GianThaMan

Flush
Supporting Member
Joined
Jan 2, 2020
Messages
2,327
Reaction score
3,229
Location
New York
I don't think a knowledge of combinations and permutations makes you a mathematics savant. I learned that kind of thing in middle school.
 
Joined
Aug 4, 2015
Messages
4,573
Reaction score
10,174
Location
Fredericksburg, VA
Not really, but gonna need to narrow it down a bit using Excel and a couple of parameters.
You should see if you can find someone with access to Tableau. They can create parameters that you can adjust and recalculate the results on the fly. Makes what if's much easier. I would be more than happy to do it for you, but that would result in misappropriation of govt resources :)
 

AWenger

Flush
Supporting Member
Joined
Jan 12, 2014
Messages
2,120
Reaction score
2,807
Location
Washington DC
There is an Excel formula for Combinations and Permutations.

There's also a COMBINA, that includes "repetitions", or counts items a different order as an additional result, I think. So COMBINA result should always be higher than COMBIN.


1596573774855.png


1596574933881.png
 

RainmanTrail

Straight Flush
Joined
Dec 21, 2015
Messages
8,370
Reaction score
17,354
Location
CA
You should see if you can find someone with access to Tableau. They can create parameters that you can adjust and recalculate the results on the fly. Makes what if's much easier. I would be more than happy to do it for you, but that would result in misappropriation of govt resources :)

Tableau Public is free
 
Top Bottom