QUESTIONS: a. Sort the carriers in decending order by their current year 's percentage of on-time deliveries. Which carrier is providing the best service in the current year? Which carrier is providing the worst service in the current year? b. Calculate the change in percentage of on-time deliveries from the previous to the current year for each carrier. Use Excel's conditional formatting to highlight the carriers whose on time percentage decreased from the previous year to the current year.

Previous Year Current Year On-time On-time Carrier Percentage Percentage Blue Box Shipping 88.4% 94.8% Cheetah LLC 89.3% 91.8% Granite State Carriers 81.8% 87.6% Honsin Limited 74.2% 80.1% Jones Brothers 68.9% 82.8% Minuteman Company 91.0% 84.2% Rapid Response 78.8% 70.9% Smith Logistics 84.3% 88.7% Super Freight 92.1% 86.8%