Exercise 2-30 Algo

Ian Stevens is a human resource analyst working for the city of Seattle. He is performing a compensation analysis of city employees. The accompanying data set contains three variables: Department, Job Title, and Hourly Rate (in $). A few hourly rates are missing in the data.

Department	Job Title	Hourly Rate
Public Utilities	Res&Eval Asst	33.09
Sustainability & Environ Dept	StratAdvsr3,Exempt	62.62
Public Utilities	Capital Prjts Coord, Asst	42.72

a. Split the data set into a number of subsets based on Department.

b. Which subset contains missing values? How many missing values are in that data set?

c. Use the imputation strategy to replace the missing values with the median of the variable. What is the average hourly rate for each subset? (Round your answer to two decimal places.)