In the textbook companion site, access the motion chart for the Baltimore housing data. Set the x axis to “% of Residential Properties Vacant” and the y axis to “% of Properties Under Mortgage Foreclosure.”

a) What was the 2001 “% of Residential Properties Vacant” in the Madison/East End community?
b) What was the 2001 “% of Properties Under Mortgage Foreclosure” in the Madison/East End community?
c) What was the 2010 population in the Madison/East End community?
d) What was the 2010 “% of Properties Under Mortgage Foreclosure” in the Madison/East End community?

Transcribed Image Text:

Original 2000-2009 Housing data set Original 2010-2014 Housing data set Original population data set Get all three data sets • Explore data; choose subset of housing indicators (no missing values) • Remove the year 2000 (not enough data) • Remove "Baltimore City" row from each housing data set Merge all data sets Reformat variables Processed Baltimore housing data