b

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. I. Click here for the Excel Data. File 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