Mathematics Savant Needed (1 Viewer)

chkmte

Flush
Joined
Apr 29, 2016
Messages
1,941
Reaction score
1,106
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,601
Reaction score
1,933
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
6,639
Reaction score
10,405
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,106
Location
MO
Wow. Thanks for that prompt reply everyone.
 

chkmte

Flush
Joined
Apr 29, 2016
Messages
1,941
Reaction score
1,106
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,467
Reaction score
3,447
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
6,040
Reaction score
14,031
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
Joined
Jan 12, 2014
Messages
2,334
Reaction score
3,178
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
Supporting Member
Joined
Dec 21, 2015
Messages
9,052
Reaction score
19,733
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