Quote:
This one: http://davidmlane.com/hyperstat/A2301.html
I haven't put much time into it, but there must be a way to edit the formula so excel doesn't use the FACT( ) formula. It's dividing by a factorial too, so it's not really using huge numbers. Perhaps there's another program that could handle plugging the original formula in, I just don't know it. It was a fun thing to try to figure out.
Just skip it altogether -- what you're reading in the first part of the equation is a standard formula for combinations ---
Combinations of n objects taken r ways = C(n,r) = n!/r!(n-r)!
In Excel, you can simplify this by using the function COMBIN(n,r)
There's also a function for Permutations PERMUT(n,r)
Permutations just removes r! from the denominator in the previous formula.
By using the functions, you can eliminate any use of factorial.