Ohio Logistics manages the logistical activities for firms by matching companies that need products shipped with carriers that can provide the best rates and best service for the companies. Ohio Logistics is very concerned that its carriers deiver their customers' material on time, so it carefully monitors the percentage of on-time deliveries. The following table contains a list of the carriers used by Ohio Logistics and the corresponding on-time percentages for the current and previous year. Click on the datatile logo to reference the data. DATA file Previous Year On-Time Current Year On-Time Deliveries (%) Deliveries (%) Carrier 38.4 91.6 Blue Box Shipping Cheetah LLC 99.3 91.8 81.8 87.6 74.2 8.1 Granite State Carriers Honsin Limited Jones Brothers Minuteman Company 68.9 82.8 9:00 81.2 78.8 70.9 Rapid Response Smith Logistics Super Freight 84.3 SH.7 92.1 86.6 (a) Sort the carriers in descending order by their current year's percentage of on-time deliveries and answer the following questions. Which carrier is providing the best service in the current year? - Select your answer - Which carrier is praviding the worst service in the current year? - Select your answer - (b) Calculate the change in percentage of on-time deliveries from the previous to the current year for cach carrier. Use Excel's conditional formatting tool to choose the correct list of carrier whase on-time percentage decreased from the previous year to the current year. (0) Carrier (u) Carrier Jones Brothers Rapid Response Minuteman Minuteman Company Company Smith Logistics Super Freight (111) Carrier (lv) Carrier Thonsin Limited Minuteman Granite State Company Carriers Granite State Super Freight Carriers Rapid Response Super Freight Cheetah LLC - Select your