Even though Daniel increased his capacity by adding more workers to his normal contingent of 30, he knew that for many weeks he exceeded his regular output of 30 shipments per week. A review of his turnover over the past 8 weeks shows the following: Boston Electric Generators has been getting many complaints from its major customer, Home Station, about the quality of its shipments of home generators. Daniel Shimshak, the plant manager, is alarmed that a customer is providing him with the only information the company has on shipment quality. He decides to collect information on defective shipments through a form he has asked his drivers to complete on arrival at customers' stores, They show the following over the past 8 weeks: No. of Reason for Defective Shipment No. of Shipments Shipments Incorrect Incorrect Damaged Trucks Truck load WEEK NO. OF TERMINATIONS 0 NO. OF NEW MIRES 1 2 3 TOTAL NO. OF WORKERS 30 31 32 1 Week 2 3 with Defects Ball Product Late 4 0 1 12 3 O D S 34 2 2 2 31 3 7 3 O 1 6 7 4 32 35 36 3 23 12 3 4 1 4 3 4 41 2 0 0 1 20 5 7 2 2 2 6 30 9 3 3 7 44 12 1 See next page! 8 33 7 0 om Use Excel to draw your diagram and charts. a) Develop a scatter diagram using the total number of shipments and the number of defective shipments. Does there appear to be any relationship? b) Develop a scatter diagram using the variable "turnover" (number of new hires plus number of terminations) and the number of defective shipments. Does the diagram depict a relationship between the two variables? In Excel Calculated the correlation coefficient between these two variables and interpret the resultant value to support your answer. c) Develop a Pareto chart for the type of defects that have occurred