Using Excel to Calculate Factorials, Permutations, and Combinations
In this week’s assignment, we will learn how to use Excel to calculate factorials, permutations and combinations.
A resource to Section 4-4 of
Stats Video Collection
Assignment
View the video and then complete the following tasks in a blank Excel worksheet.
4-4 Using Excel to Calculate Factorials, Permutations and Combinations [04:58]
· In cell A1, compute 3 factorial
· In cell A2, calculate the number of permutations when selecting three items from a total of ten items.
· In cell A3, calculate the number of combinations when selecting three items from a total of ten items.
Save the completed worksheet as
W3_Assignment.xls