Q26. (30 pts) Parts b, c, d, e, f. For parts d and e, copy the charts from the excel spreadsheet into your answers. Remember to label your axes. For part f, you can comment on whether Speedy Swift has achieved their objectives. 26. FILE Speedy Swift is a package delivery service that serves the greater Atlanta, Georgia, metropolitan area. To maintain customer loyalty, one of Speedy Swift's performance objectives is on-time delivery. To monitor its performance, each delivery is measured on the following scale: early (package delivered before the promised time). on-time (package delivered within 5 minutes of the promised time), late (package delivered more than 5 minutes past the promised time) or lost (package never delivered). Speedy Swift's objective is to deliver 99% of all packages either early or on-time. Speedy collected the following data for last month's performance: On-time On-time Early Late On-time On-time On-time On-time Late On-time On-time On-time Early On-time On-time On-time On-time On-time On-time Early Early On-time On-time On-time On-time Early On-time On-time On-time Early On-time Early On-time Late Early Early On-time On-time On-time Early On-time Late Late On-time On-time On-time On-time On-time On-time On-time On-time Late Early On-time Early On-time Lost On-time On-time On-time Early Early On-time On-time Late Early Lost On-time On-time On-time On-time On-time Early On-time Early On-time Early On-time Late On-time On-time Early On-time On-time On-time Late On-time Early On-time On-time On-time On-time On-time On-time On-time Early Early On-time On-time On-time Page 44 a. What kind of variable is delivery performance? What scale is used to measure delivery performance? b. Construct a frequency table for delivery performance for last month. c. Construct a relative frequency table for delivery performance last month. d. Construct a bar chart of the frequency table for delivery performance for last month. e. Construct a pie chart of on-time delivery performance for last month. f. Write a memo reporting the results of the analyses. Include your tables and graphs with written descriptions of what they show. Conclude with a general statement of last month's delivery performance as it relates to Speedy Swift's performance objectives