PLEASE ANSWER ALL FOR UPVOTE THANKS

c. Select a appropriate Pareto diagram for the Commercial customers. Required information [The following information applies to the questions displayed below.] An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week, as shown in the table. Click here for the Excel Data File b. Select a appropriate Pareto diagram for the Residential customers A,BRC a. Using the data, prepare a check sheet for the problem types for each customer type. (1) Residential customer type (2) Commercial customer type