Description
a. Briefly describe positive or negative correlation you see in the correlation matrix and hypothesize why you think such correlation exist in the attached matrix b. Describe any correlation that goes against conventional thinking (if any) and warrants further investigation c. Briefly describe how data analysis might be useful for an agent, a buyer, or a seller. What insights may be useful for the end user (agent, buyer, or seller) based on the analysis completed? (Note: Pick hypothetical example using neighborhood or zip code to demonstrate your point. Create additional visuals or charts relevant to support your hypothesis.) These are the variables of the correlation matrix – Sold Price(house), bedroom, bathroom, Year build, Days on Zillow, Square Feet, drugcrime16lessthan.5 (is the number of drug crimes in 2016(, murdercrime16lessthan.5 ( is the number of murder crimes in 2016), rest_.5 (is the number of restaurants) and subwaycountlessthan1 (is the number of subway stations .25 miles away) I’ll attach a file with the correlation matrix
Correlation Matrix
| Year Built | Bed | Bath | Days on Zillow | Sq Ft | rest_.5 | subwaycountlessthan1 | drugcrime16lessthan.5 | murdercrime16lessthan.5 | Sold Price | |
| Year Built | 1.00 | -0.01 | 0.18 | 0.01 | 0.05 | -0.32 | -0.37 | -0.29 | -0.19 | -0.14 |
| Bed | -0.01 | 1.00 | 0.49 | -0.02 | 0.35 | 0.15 | 0.24 | 0.21 | 0.15 | 0.17 |
| Bath | 0.18 | 0.49 | 1.00 | -0.01 | 0.29 | 0.03 | 0.06 | 0.05 | 0.04 | 0.24 |
| Days on Zillow | 0.01 | -0.02 | -0.01 | 1.00 | 0.01 | 0.00 | 0.00 | 0.00 | -0.02 | -0.11 |
| Sq Ft | 0.05 | 0.35 | 0.29 | 0.01 | 1.00 | 0.15 | 0.20 | 0.19 | 0.13 | 0.32 |
| rest_.5 | -0.32 | 0.15 | 0.03 | 0.00 | 0.15 | 1.00 | 0.53 | 0.45 | 0.08 | 0.47 |
| subwaycountlessthan1 | -0.37 | 0.24 | 0.06 | 0.00 | 0.20 | 0.53 | 1.00 | 0.66 | 0.45 | 0.30 |
| drugcrime16lessthan.5 | -0.29 | 0.21 | 0.05 | 0.00 | 0.19 | 0.45 | 0.66 | 1.00 | 0.57 | 0.18 |
| murdercrime16lessthan.5 | -0.19 | 0.15 | 0.04 | -0.02 | 0.13 | 0.08 | 0.45 | 0.57 | 1.00 | -0.06 |
| Sold Price | -0.14 | 0.17 | 0.24 | -0.11 | 0.32 | 0.47 | 0.30 | 0.18 | -0.06 | 1.00 |