In the Baltimore housing data motion chart, go to the bar chart tab and set the y axis to “% of Properties Under Mortgage Foreclosure” (leave the x axis on “Order: % of Properties Under Mortgage Foreclosure”).

a) Which community had the highest “% of Properties Under Mortgage Foreclosure” in 2005?
b) Which community had the highest “% of Properties Under Mortgage Foreclosure” in 2013?

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