Comparing Package Delivery Drivers. Red Sky Delivery performs last-mile delivery services for online retailers such as Amazon. Red Sky employs delivery drivers who perform the last-mile of delivery service by delivering packages to individual residence and business locations. 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 RedSkyDeliveries, create a column chart to display the information in the table above. Format the column chart to best display the data. Use a chart title of Comparing Red Sky Delivery Drivers and a vertical-axis title of Average number of deliveries per shift. Get rid of any unnecessary gridlines and 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 for the audience to see which drivers have the highest and lowest average number of delivery stops per shift.

c) Further investigation by Red Sky indicates that all of these delivery drivers except Amy Urbaczewski have similar delivery routes. Amy typically delivers in more rural areas while all other drivers support more urban routes. Red Sky wants to draw attention to the fact that Amys routes are different than the others. Modify the sorted column chart by changing the color of the column associated with Amy Urbaczewski to indicate that this column is different from the others.

\begin{tabular}{lr} Delivery Driver & AverageNumberofDeliveryStopsCompleted(pershift) \\ \hline Amy Urbaczewski & 92.87 \\ \hline Sally Melouk & 110.78 \\ \hline Brenda Barnes & 114.2 \\ \hline Jonathan Payne & 132.5 \\ \hline Bruce Wheeler & 148.2 \\ \hline Cam Madsen & 87.51 \\ \hline Sheila Stevens & 139.82 \\ \hline Grant Inhara & 154.23 \\ \hline Finn Helton & 109.11 \\ \hline \end{tabular}