In: Statistics and Probability
3. A package delivery service adopted a new dispatching system to try to reduce the total mileage required by its truck fleet to make deliveries. The new system would be worth the cost if it reduced the fleet mileage by more than 10% from its current level of 2200 miles per day. The miles required for each of the 66 days under a trial of the new system are recorded in column 1 of the Excel data file named “Package Delivery”. Using the given data and 7% level of significance, please conduct an appropriate test to determine if the new dispatching system is worth its cost. Based on your results, do you think the new system is worth its cost? Show the necessary steps and explain your conclusion
Miles | Day |
2475 | 1 |
2433 | 2 |
2020 | 3 |
1975 | 4 |
1759 | 5 |
1582 | 6 |
1635 | 7 |
1492 | 8 |
1757 | 9 |
1690 | 10 |
1834 | 11 |
2261 | 12 |
1845 | 13 |
2122 | 14 |
1972 | 15 |
2056 | 16 |
2072 | 17 |
2028 | 18 |
2063 | 19 |
1795 | 20 |
1840 | 21 |
1762 | 22 |
1856 | 23 |
2030 | 24 |
1996 | 25 |
2153 | 26 |
2208 | 27 |
2049 | 28 |
2186 | 29 |
2214 | 30 |
1934 | 31 |
1959 | 32 |
1985 | 33 |
2026 | 34 |
2425 | 35 |
2194 | 36 |
2035 | 37 |
2190 | 38 |
2295 | 39 |
2152 | 40 |
1770 | 41 |
1666 | 42 |
1673 | 43 |
1804 | 44 |
1647 | 45 |
1754 | 46 |
1713 | 47 |
1867 | 48 |
2402 | 49 |
2030 | 50 |
1996 | 51 |
2153 | 52 |
2208 | 53 |
2049 | 54 |
2265 | 55 |
1863 | 56 |
1754 | 57 |
1761 | 58 |
1899 | 59 |
1734 | 60 |
1846 | 61 |
1803 | 62 |
1965 | 63 |
2528 | 64 |
2137 | 65 |
2101 | 66 |