Question

AutoSave OFF BESU: 2 M4 expected values company updated Home Insert Draw Page Layout Formulas Data Review View Tell me Share O Comments Insert v v X La Calibri (Body) = = 12 . Å ab Wrap Text General Do 國留通 WE 49" . Ou 8 Delete v Paste BI U A Merge & Center $ % ) .00 00 20 Conditional Format Formatting as Table Cell Styles Ideas Sort & Filter Format Find & Select Sensitivity Yes No Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? A8 ✓ fx A B с F G 1 You must use Excel commands/functions on all of your calculations in order to earn full credit. H - J K L M N O P Q R s т U V w х 2 5 8 #N/A 14 3 Complete the following questions: 1) How many 6-character passwords can be generated using one letter from a to hand 5 numbers from 1 to 9? #N/A 6 7 2) How many ways can you choose a complete dinner from a menu that allows you to pick from 2 salads, 3 entrees, and 2 desserts? #N/A 9 10 3) How many ways can you pick a committee of 16 students from a class of 30 students? 11 12 13 4) How many ways can you pick a president, vice-president, secretary, & a treasurer from a club of 8 people? #N/A 15 16 5) How many ways can you make a line-up for a music festival if you can have 5 bands play out of 10 bands who applied to play? 17 #N/A 18 19 6) How many ways can you pick 3 essay questions to answer on a test that offers 7 essay questions to pick from? 20 #N/A 21 22 7) A local company has determined the number of machine breakdowns 23 per month and their results are below: 24 25 Breakdowns Probability 26 0.09 27 1 0.26 2 0.34 0.15 30 0.12 31 5 0.04 32 33 34 Use the SUMPRODUCT function in Excel to answer. 35 36 The expected number of machine breakdowns per month is: 37 38 #N/A 39 40 0 28 29 3 4 Sheet1 + A Ready - + 96%

Answer 1

We would be looking at the first 4 parts here:

a) The number of 6-character passwords that can be generated using one letter from a to h and 5 numbers from 1 to 9 is computed here as:

= Number of ways to select 1 letter from 8 letters from a to h * Number of ways to select 5 numbers from 1 to 9 * Number of permutations of 6 characters selected.

This is computed in EXCEL as:
=combin(8,1)*combin(9,5)*fact(6)

725760 is the output here.

b) Number of ways to choose the dinner here is computed as:

= Number of ways to select one of the 2 salads * Number of ways to select one of the 3 entrees * Number of ways to select one of the 2 desserts

This is computed in EXCEL as:
=combin(2,1)*combin(3,1)*combin(2,1)

12 is the output here.

c) The number of ways to pick a committee of 16 students from a class of 30 students is computed here as:

= Number of ways to select 16 students from 30 students

This is computed in EXCEL as:
=combin(30,16)

145422675 is the output here.

d) The number of ways to pick a president, vice president, secretary and treasurer from a club of 8 people is computed here as:

= Number of permutations of 8 people taken 4 at a time

This is computed in EXCEL here as:
=PERMUT(8,4)

1680 is the output here.