Problem $9-2($Algo$)$

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

$\backslash$table$[[\backslash$table$[[$Job$],[$Number$]],\backslash$table$[[$Customer$],[$Type$]],\backslash$table$[[$Problem$/],[$Number$],[$Customer$],[$Type$]],\backslash$table$[[$Job$],[$Number$]],\backslash$table$[[$Problem$/],[$Customer$],[$Type$]],],[301,$F$/$R$,315,$O$/$R$,329,$W$/$C$],[303,$N$/$R$,316,$F$/$R$,330,$F$/$C$],[304,$N$/$R$,317,$O$/$R$,331,$N$/$R$],[305,$N$/$R$,318,\frac{0}{C},332,$W$/$C$],[306,$O$/$R$,319,$N$/$R$,333,$O$/$R$],[307,$F$/$C$,320,$O$/$R$,334,$W$/$C$],[308,$N$/$R$,321,$F$/$R$,335,$O$/$C$],[309,$F$/$R$,322,$W$/$R$,336,$F$/$R$],[310,$O$/$C$,323,$O$/$C$,337,$N$/$C$],[311,$W$/$C$,324,$N$/$R$,338,$F$/$R$],[312,$N$/$R$,325,$O$/$R$,339,$N$/$R$],[313,$O$/$R$,326,$O$/$C$,340,$O$/$C$],[314,$O$/$R$,327,$O$/$C$,341,$O$/$R$],[,$F$/$R$,328,$F$/$C$,,]]$

Click here for the Excel Data File

$\backslash$table$[[$Key: Problem type:,Customer type:$],[N=$ Noisy,$C=$ Commercial$],[\backslash$table$[[F=$ Equipment$],[W=$ Ruilure$],[0=0$ dor$]],\{$fdeeb$984$b$-453$c$-4$f$02-93$f$0-39$e$44$d$686$b$1$b$\}$

$\backslash$table$[[$Residential$],[$customer$]]]]$

Problem $9-2$ Part a $($Algo$)$

a$.$ Using the data, prepare a check sheet for the problem types for each customer type.

$(1)$ Residential customer type

Answer is complete but not

$\backslash$table$[[,$Residential$],[$Odour$,10$