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. Job Number 315 316 Job Number 301 302 303 304 305 306 307 308 309 310 311 312 313 314 Problem/ Customer Type N/c N/R N/R N/C F/R F/R N/C o/c E/R o/c W/C W/R N/R o/c 317 318 319 320 321 322 323 324 325 326 327 328 Problem/ Customer Type N/R W/C F/C N/R w/c P/ P/R P/C O/R N/C F/R N/R N/R F/C Job Number 329 330 331 332 333 334 335 336 337 338 339 340 341 Problem/ Customer Type N/R O/R N/R W/C O/R E/R /R N/C O/R T/ N/R O/R O/R Click here for the Excel Data File Keyi Problem type: N- Noisy P- Equipment failure W-Runs warm O - 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 Odour Totals (2) Commercial customer type Commercial Warm Odor Failed Noisy