Department Job Title Hourly Rate Split the data set into a number of subsets based on Department. How many subsets are created?

Public Utilities Res&Eval Asst $32\mathrm{.}81$ Which subset contains missing values?

Sustainability & Environ Dept StratAdvsr$3,$Exempt $62\mathrm{.}267$ How many missing values are in that data set?

IT Dept Info Technol Prof A $*56$ Use the imputation strategy to replace the missing values with the mean of the variable. What is the average hourly rate for each subset?

Public Utilities Wtr Systs Supv $53\mathrm{.}13$

Public Utilities Laborer $*22\mathrm{.}19$

IT Dept Manager$2,$Info Technol $59\mathrm{.}933$

IT Dept Mgmt Systs Anlyst,Sr $48\mathrm{.}09$

IT Dept Info Technol Prof B$-$BU $*53\mathrm{.}62$

Public Utilities Info Technol Prof C$-$BU $46\mathrm{.}989$

Public Utilities Wtr Syst Op $43\mathrm{.}03$

Public Utilities Drainage&Wstwtr Coll CC $40\mathrm{.}96$

Public Utilities Fin Anlyst $38\mathrm{.}89$

IT Dept Info Technol Prof A$,$Exempt $64\mathrm{.}413$

Public Utilities Fin Anlyst,Sr $46\mathrm{.}13$

IT Dept Info Technol Prof B$-$BU $58\mathrm{.}611$

Public Utilities Executive$273\mathrm{.}98$

Public Utilities Manager$3,$Engrng&Plans Rev $66\mathrm{.}267$

Public Utilities Wtr Meter Repairer $31\mathrm{.}24$

Public Utilities Grounds Maint CC $37\mathrm{.}23$

Public Utilities Truck Drvr$,$Heavy $32\mathrm{.}35$

Public Utilities Util Act Rep Trne $24\mathrm{.}28$

Public Utilities Wtr Pipe Wkr Sr$-$WDM II $37\mathrm{.}53$

IT Dept Cmputr Op$,$Sr $*24\mathrm{.}76$

IT Dept Info Technol Prof A$,$Exempt $57$

IT Dept Info Technol Prof A$,$Exempt $57\mathrm{.}252$

IT Dept Info Technol Prof B$-$BU $52\mathrm{.}53$

Public Utilities Util Act Rep I $26\mathrm{.}09$

Public Utilities Manager$3,$Utils $59\mathrm{.}59$

Public Utilities Envrnmtl Anlyst,Sr $47\mathrm{.}97$

Public Utilities StratAdvsr$2,$Engrng&Plans Rev $58\mathrm{.}776$

Public Utilities Util Act Rep Trne $23\mathrm{.}32$

Public Utilities StratAdvsr$1,$Exempt $52\mathrm{.}585$

IT Dept Info Technol Prof B$-$BU $49\mathrm{.}703$

Public Utilities Util Act Rep Trne $23\mathrm{.}32$

IT Dept Info Technol Prof B$-$BU $52\mathrm{.}18$

Public Utilities Util Act Rep I $29\mathrm{.}3$

Public Utilities Civil Engrng Spec,Assoc $38\mathrm{.}24$

Dept Of HR StratAdvsr$1,$Exempt $48\mathrm{.}879$

IT Dept Info Technol Prof B$-$BU $56\mathrm{.}39$

IT Dept Info Technol Prof B$-$BU $56\mathrm{.}666$

Public Utilities Truck Drvr$,$Heavy $31\mathrm{.}08$

Public Utilities StratAdvsr$1,$Utils $42\mathrm{.}9186$

Public Utilities Wtr Pipe Wkr Sr$-$WDM II $37\mathrm{.}53$

Public Utilities Real Property Agent $36\mathrm{.}47$

IT Dept Info Technol Systs Anlyst $*38\mathrm{.}28$

Public Utilities Civil Engr,Sr $58\mathrm{.}53$

Public Utilities Civil Engrng Spec,Assoc $39\mathrm{.}73$

Public Utilities Wtr Quality Anlyst $32\mathrm{.}17$

Dept Of HR Admin Staff Anlyst $*34\mathrm{.}76$

IT Dept Executive$275\mathrm{.}562$

Public Utilities Util Svc Inspector $38\mathrm{.}76$

IT Dept Cooperative Intern $*16\mathrm{.}56$

Public Utilities Civil Engr,Sr $58\mathrm{.}53$

Sustainability & Environ Dept Plng&Dev Spec,Sr $41\mathrm{.}26$

IT Dept Info Technol Prof C$-$BU $48\mathrm{.}668$

Public Utilities Carpenter $33\mathrm{.}78$

IT Dept Info Technol Prof B$-$BU $57\mathrm{.}461$

IT Dept StratAdvsr$2*53\mathrm{.}43$

Public Utilities Manager$3,$Utils $63\mathrm{.}409$

Public Utilities Envrnmtl Fld Spec $35\mathrm{.}41$

Public Utilities Economist,Prin $54\mathrm{.}57$

Public Utilities StratAdvsr$2,$Utils $55\mathrm{.}423$

Public Utilities Wtr Pipe CC$-$WDM II $43\mathrm{.}26$

Public Utilities Wtr Pipe Wkr $33\mathrm{.}66$

Public Utilities Wtr Pipe Wkr $33\mathrm{.}66$

IT Dept Info Technol Prof B$-$BU $48\mathrm{.}95$

Public Utilities Civil Engr,Assoc $47\mathrm{.}18$

Public Utilities Wtrshed Opns Supv $44\mathrm{.}57$

Public Utilities Wtr Quality Anlyst,Supv $43\mathrm{.}73$

Public Utilities Capital Prjts Coord,Sr $54\mathrm{.}9$

IT Dept Info Technol Systs Anlyst $42\mathrm{.}92$

Public Utilities Civil Engrng Spec,Assoc $42\mathrm{.}85$

Public Utilities Truck Drvr$,$Heavy $32\mathrm{.}35$

Public Utilities Actg Tech II$-$BU $27\mathrm{.}18$

Public Utilities Util Act Rep II $32\mathrm{.}96$

Public Utilities Wtr Pipe Wkr$-$WDM I $33\mathrm{.}98$

IT Dept Admin Staff Asst $34\mathrm{.}07$

Public Utilities Maint Laborer $26\mathrm{.}09$

IT Dept StratAdvsr$2,$Info Technol $41\mathrm{.}501$

Public Utilities Scale Attendant $25\mathrm{.}4$

Public Utilities Util Svc Rep $35\mathrm{.}78$

Public Utilities Envrnmtl Anlyst,Sr $49\mathrm{.}77$

Public Utilities Drainage&Wstwtr Coll Wkr $30\mathrm{.}74$

IT Dept Info Technol Prof B$-$BU $55\mathrm{.}471$

IT Dept Info Technol Prof A$,$Exempt $59\mathrm{.}758$

Dept Of HR Personnel Anlyst,Sr $43\mathrm{.}73$

Public Utilities Civil Engrng Spec,Assoc $44\mathrm{.}51$

Public Utilities Executive$270\mathrm{.}616$

IT Dept Info Technol Systs Anlyst $42\mathrm{.}92$

Public Utilities Drainage&Wstwtr Coll Wkr CI $31\mathrm{.}33$

IT Dept StratAdvsr$2,$Exempt $56\mathrm{.}837$

Public Utilities Scale Attendant $25\mathrm{.}4$

IT Dept Info Technol Prof B$-$BU $50$

Dept Of HR Mgmt Systs Anlyst $34\mathrm{.}76$

Public Utilities Constr&Maint Equip Op $34\mathrm{.}01$

Dept Of HR Mgmt Systs Anlyst,Sr $*41\mathrm{.}26$

Public Utilities Admin Staff Anlyst $*37\mathrm{.}59$

IT Dept Info Technol Systs Anlyst $42\mathrm{.}92$

Public Utilities Wtr Pipe Wkr$-$WDM I $32\mathrm{.}7$

IT Dept Info Technol Prof A$,$Exempt $64\mathrm{.}578$

Public Utilities Actg Tech II$-$BU $27\mathrm{.}18$

IT Dept Info Technol Prof A $*60\mathrm{.}623$

IT Dept Manager$2,$Fin,Bud,&Actg $51\mathrm{.}88$

Dept Of HR Personnel Anlyst,Asst $31$

Public Utilities StratAdvsr$2,$Utils $51\mathrm{.}93$

IT Dept StratAdvsr$2*50$

Public Utilities Trng&Ed Coord $33\mathrm{.}45$

Public Utilities Envrnmtl Anlyst,Sr $49\mathrm{.}77$

Public Utilities Civil Engrng Spec,Assoc $4$