1/ A department store places weekly orders for supplies from the distributor. The weekly order consists of a product code and quantity (two opportunities for a defect). The distributor delivers on Friday and the total quantity is unpacked and checked for shipping damage. The store then places labels on every item (the total quantity in the order). After labeling, all the items are arranged by product and stacked (all items of the same type are placed in a single container - there is only one opportunity for a defect per product when stacking). It is observed that some of the items are put in the wrong racks. Using the data in the spreadsheet below, what is the total DPMO?

Use Data Set A from provided Excel file..

2/ Given the data in the spreadsheet below, what is the probability of completing the critical path of the project in 34 or more time units?

Use Data Set B from the given Excel file

3/Given the cash flow in the spreadsheet below, what is the internal rate of return? Please enter your answer as a decimal not as a percent. For example enter 0.153 not 15.3%.?

Use Data Set C in the provided Excel sheet

4/Using Data Set D in the provided Excel file, calculate the mean?

5/Using Data Set D in the provided Excel file, calculate the variance?

6/Using Data Set D in the provided Excel file, calculate the standard error. ?

7/Using Data Set D in the provided Excel file, calculate the skewness (Note: use Type 2).

Home Insert Draw Tell me Share Comments A1 4 fx Level 1 F G - H A B D E 1 Level 1 Level 2 Level 3 Level 4 Level 5 2 77.2 110.9 83.5 68.8 95.5 3 86.9 45.4 68.2 106.7 69.2 4 106.4 45.8 90.2 90.8 34.7 5 45.5 114.2 54.8 109.4 6 104.7 109.4 102.5 128.3 7 42 30.6 104.8 115.7 8 84.5 90.9 41.9 98.4 9 67.8 39.6 112.6 102.2 10 22.3 52.6 57.7 66.3 11 57 100.5 76.9 79 12 90.8 92.2 104 13 65 70.6 99.4 14 39.3 71.8 15 47.1 47.4 16 115.4 51.3 17 83.1 108.4 18 57.9 75.4 19 61.9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Level 6 86.4 31.4 52 76.5 58.2 106.8 41.9 102.3 47.6 114.7 46.5 126 107.8 126.6 116.3 51 104.9 27 Data Set F Data Set G + Home Insert Draw Tell me Share Comments A1 4 fx Level 1 F G - H A B D E 1 Level 1 Level 2 Level 3 Level 4 Level 5 2 77.2 110.9 83.5 68.8 95.5 3 86.9 45.4 68.2 106.7 69.2 4 106.4 45.8 90.2 90.8 34.7 5 45.5 114.2 54.8 109.4 6 104.7 109.4 102.5 128.3 7 42 30.6 104.8 115.7 8 84.5 90.9 41.9 98.4 9 67.8 39.6 112.6 102.2 10 22.3 52.6 57.7 66.3 11 57 100.5 76.9 79 12 90.8 92.2 104 13 65 70.6 99.4 14 39.3 71.8 15 47.1 47.4 16 115.4 51.3 17 83.1 108.4 18 57.9 75.4 19 61.9 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 Level 6 86.4 31.4 52 76.5 58.2 106.8 41.9 102.3 47.6 114.7 46.5 126 107.8 126.6 116.3 51 104.9 27 Data Set F Data Set G +