Ian Stevens is a human resource analyst working for the city of Seattle. He is performing a

Question:

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?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Business Analytics Communicating With Numbers

ISBN: 9781260785005

1st Edition

Authors: Sanjiv Jaggia, Alison Kelly, Kevin Lertwachara, Leida Chen

Question Posted: