⇒ index.Rmd

The Impact of 2008 Economic Crisis across the U.S.

Team Citris (Sona, Ines, Sho, Jamie)

• Which social group was negatively affected the most after 2008 crisis by unemployment rate

• Bureau of Labor Statistics (BLS)

  • Demographic Data (http://www.bls.gov/lau/table14full + Year (last two digits) + “.xlsx”)
  • Industry Data (http://www.bls.gov/cew/datatoc.htm)

• Main Variables to Investigate (2004-2014)

  • Unemployment Rate
  • Age, Gender, Ethnicity
  • Industry
  • Region

• Methods

  • Data Merging: for loops/join
  • Data Cleaning :regrex,filter,mutate,grepl, ifelse

##   Year                   State              Industry Avg.EmpLvl Avg.Pay
## 1 2014 California -- Statewide Total, all industries   15809082   59042
## 2 2007 California -- Statewide Total, all industries   15640575   50538
## 3 2006 California -- Statewide Total, all industries   15503144   48345
## 4 2008 California -- Statewide Total, all industries   15494915   51487
## 5 2013 California -- Statewide Total, all industries   15378962   57111
##   Pre.Recession.EmpLvl EmpLvl.change
## 1             15332732   0.031067506
## 2             15332732   0.020077488
## 3             15332732   0.011114245
## 4             15332732   0.010577551
## 5             15332732   0.003015102

Analysis on Employment level- Region/Industry

Which demographic group was negatively affected the most?

in which region?