lan 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

Public Utilities

Sustainability &

Environ Dept

Job Title

Res&Eval Asst

StratAdvsr$3,$ Exempt

Hourly Rate

$32\mathrm{.}98$

$62\mathrm{.}05$

Public Utilities

Capital Prits Coord,

Asst

$42\mathrm{.}95$

picture Click here for the Excel Data File

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