04-06-2018, 03:14 AM
(04-05-2018, 11:42 PM)Lissa Wrote: Overall, you're looking at the Combination (and a lesser extent Permutation) forumla.
C(n,r) = n! / [r! x (n - r)!]
Where n is the set size (10 in this case) and r is the set that makes up the valid choices (so in the case where 9 or 10 is what you're looking for, it would be 2).
For Permutation, the formula removes the multiple of r!
P(n,r) = n! / (n - r)!
Hi Lissa, and thank you for your response. I have a few questions;
Using the Combination formula, I seem to be getting a bell curve when I expected instead to see increasing returns. How might the output be interpreted? I may be applying the formula incorrectly. FACT in Excel applies a Factorial (!) to whatever is in "()".
"The true value of a human being is determined primarily by the measure and the sense in which he has attained liberation from the self." -Albert Einsetin