Question

Using Excel to Calculate Factorials, Permutations, and Combinations

Using Excel to Calculate Factorials, Permutations and Combinations"

·         In cell A1, compute 3 factorial

·         In cell A2, calculate the number of permutations when selection 3 items from a total of ten items.

·         In cell A3, calculate the number of combinations when selecting 3 items from a total of ten items.

Answer 1

Now the question is to calculate the factorial, permutations, and combinations according to the mathematics:

To find the factorial of 3, here the formula

3! = 3 x 2 x 1 = 6

whereas in excel we defined as using the function fact

=fact(3) = 6

to calculate the number of permutations when selecting 3 items from a total of ten items, accroding to the mathmatics:

the formula:

when n = 10 and r = 3

where as in excel we use the function, PERMUT

=PERMUT(10,3) which is equal to 720

to calculate the number of the combination when selecting 3 items from a total of ten items, according to the mathematics:

where n = 10 and r = 3

= 120

now in the excel use of the function COMBIN

= COMBIN(10,3)

Now you can download the excel sharing the link where the above three operations are performed:

https://docs.google.com/spreadsheets/d/1dvS64kt9O4Kf63B6SIHyQpTPNy3qWLD7Adv55JNL1GI/edit?usp=sharing