Red Sky Delivery performs “last-mile” delivery services for online retailers such as Amazon. Red Sky employs delivery drivers who deliver packages to individual residence and business locations from a local transportation hub. Red Sky measures several delivery driver performance metrics, including number of delivery stops completed per eight-hour shift. The table below provides data on nine Red Sky delivery drivers and their average number of packages delivered per shift over the previous 30 days.

a. Using the data in the file redsky, create a column chart to display the information in the table above. Add data labels that show the average number of delivery stops completed for each driver.

b. Create a sorted column chart to make it easier to see which drivers have the highest and lowest average number of delivery stops per shift.

Transcribed Image Text:

Delivery Driver Amy Urbaczewski Sally Melouk Average Number of Delivery Stops Completed (per shift) 92.87 110.78 Brenda Barnes 114.20 Jonathan Payne 132.50 Bruce Wheeler 148.20 Cam Madsen 87.51 Sheila Stevens 139.82 Grant Inhara 154.23 Finn Helton 109.11