Given the observed times to process the 25 orders, what should be the manager's estimation of the coefficient of variation of the service time? Note: 1. Round your answer to 2 decimal places. 2. As in the previous question, the service time of an order includes both the time for picking the items and the time for moving them to the staging area. 3. Sample standard deviation should be used to calculate the coefficient of variation.

Note that you do not need to fit a distribution. Instead, you calculation should be based on the sample standard deviation and sample average of the service times. 4. Please make use of the same spreadsheet file that contains the times to process the orders.

AutoSave OFF 9 ... Service_times (1) AutoSave OFF no @ @y... Interarrival_times Home Insert Draw Page Layout Formulas Data >> Tell me Share Comments Home Insert Draw Page Layout Formulas >> >> Tell me Share Comments A % o A. Fm V Conditional Formatting Format as Table Cell Styles % ma Conditional Formatting Format as Table Cell Styles Clipboard Font Alignment Number Cells Editing Analyze Sens Clipboard Font Alignment Number Cells Editing Se Data Analyze Data A2 4 x fx foc A2 2x fx 2.8 7 B D D E F F A B D E E F F G H 1 Time of picking items 1 Order # (minutes) 2 #1 27 3 #2 13 4 #3 10 5 #4 17 6 #5 25 7 #6 12 8 #7 7 9 #8 26 10 #9 37 11 #10 18 12 #11 19 13 #12 33 14 #13 14 15 #14 26 16 #15 31 17 #16 23 18 #17 39 19 #18 14 60 21 #20 41 22 #21 29 23 #22 19 24 #23 34 25 #24 21 26 #25 36 Time fo checkout and moving to the staging area (minutes) 7 4 6 6 5 25 12 2 11 37 18 19 33 14 26 31 23 14 4 20 11 11 5 9 1 Interarrival times (minutes) 2 2.8 3 3 6.4 4 4 3.5 5 0.1 6 1.5 7 3.3 8 0.8 9 7.1 10 0.8 11 1.2 12 0.1 13 12.8 14 8.1 15 3.7 16 3.6 17 8.1 18 4.1 19 0.7 20 2.7 21 5.2 22 3.3 23 0.5 24 0.6 25 10 20 #19 26 6 27 15 28 27 29 28 30 29 31 30 Sheet1 + Sheet1 + Ready a + 100% Ready 100% A +