PLEASE ANSWER BOTH QUESTIONS

1. [The following information applies to the questions displayed below.]

The following are the car repair shop data:

3. [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.

[The following information applies to the questions displayed below.] The following are the car repair shop data: Click here for the Excel Data File a. Prepare a check sheet for the above car repair shop data: Answer is complete but not entirely correct. 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 a. Using the data, prepare a check sheet for the problem types for each customer type. (1) Residential customer type a. Using the data, prepare a check sheet for the problem types for each customer type. (1) Residential customer type (2) Commercial customer type