Mathematical Statistics W3

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