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. Job Problem/ Job Problem/ Job Problem/ Number Customer Type Number Customer Type Number Customer Type 301 0/R 315 N/R 329 0/R 302 F/R 316 N/R 330 F /C 303 O/ C 317 O/C 331 F/R 304 F/C 318 N/R 332 F /C 305 O/C 319 F/R 333 F/R 306 F /R 320 W/R 334 O/C 307 F /R 321 W/C 335 F /C 308 N/R 322 N/C 336 F/R 309 O/C 323 N/R 337 O/C 310 0/ R 324 0/R 338 N/R 311 0/R 325 W/C 339 N/R 312 N/C 326 0/R 340 N/R 313 F /R 327 N/C 341 0/R 314 N/C 328 N/R Click here for the Excel Data File Key: Problem type: Customer type: N = Noisy C = Commercial customer F = Equipment failure R = Residential customer W = Runs warm 0 = Odor a. Using the data, prepare a check sheet for the problem types for each customer type.Required information (1) Residential customer type Residential Failed Noisy 9 Warm Odour Totals (2) Commercial customer type Commercial Noisy Warm Odor Failed Totals