3 Part 1 of 3 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. 2 points Job Number Problem/ Customer Type 301 F/C Job Number 315 Problem/ Customer Type N/C Job Number 329 Problem/ Customer Type N/C 382 F/R 316 N/R 338 F/R 383 O/C 317 N/R 331 N/R eBook 384 O/C 318 N/C 332 N/R 385 W/C 319 N/R 333 N/R 386 W/R 320 F/R 334 N/R 387 O/R 321 D/C 335 O/C 388 N/R 322 W/C 336 W/C Hint 309 F/C 323 O/R 337 N/R 310 N/R 324 F/C 338 F/R 311 O/C 325 W/C 339 O/R 312 F/R 326 D/R 348 N/R Print 313 0/C 327 F/C 341 N/R 314 W/C 328 F/R Click here for the Excel Data File Key: Problem type: N - Noisy F-Equipment failure W-Runs warn D-Odor Customer type: C - Commercial customer R Residential customer a. Using the data, prepare a check sheet for the problem types for each customer type. (1) Residential customer type Residential Failed Noisy Warm 1 Odor 4 Totals 5 (2) Commercial customer type Commercial Failed Noisy Odor Warm Totals 0