So far, we worked to get the data into shape for analysis. We'll now start with looking at the geographical distribution of the average annual pay per state and per county.
If you have thoroughly followed the recipes in this chapter until now, you will have the data in a form from where you can extract information at different levels. We're good to go!
We will first extract data from ann2014full at the state-level. We need to perform the following steps:
- We look at the
aggregatestate-level data. A peek ataggleveltells us that the code for the level of data that we want is50. Also, we only want to look at the average annual pay(avg_annual_pay)and the average annual employment level(annual_avg_emplvl), and not the other variables:
d.state <- filter(ann2014full, agglvl_code==50) d.state <- select(d.state, state, avg_annual_pay, annual_avg_emplvl)
- We create two new variables,
wageandempquantile...