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.

 

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

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 mean of the variable. What is the average hourly rate for each subset?

Department Public Utilities Sustainability & Environ Dept Public Utilities Job Title Res&Eval Asst StratAdvsr3,Exempt Capital Prits Coord, Asst Hourly Rate 32.81 62.27 # 42.71