The file Philly contains a sample of 25 neighborhoods in Philadelphia. Variables included are neighborhood population, median sales price of homes in the second quarter of 2017, mean number of days homes were on the market in the second quarter of 2017, number of homes sold in the second quarter of 2017, median neighborhood household income, percentage of residents in the neighborhood with a bachelor’s degree or higher, and whether the neighborhood is considered “hot” (coded as 1 = yes, 0 = no).

Data extracted from bit.ly/2wlcJWs, bit.ly/2smOyVu, bit.ly/2v4mqZd, and bit.ly/2n0RNPW.

Using this data, you seek to predict median sales price of homes. Completely analyze the data.