# 1. Download the Excel file “Muni Data MT1.xlsx” from the course D2L shell. This file contains data from 19 Allegheny County, Pennsylvania municipalities from the 1990 Census. There are 3 variables in...

1. Download the Excel file “Muni Data MT1.xlsx” from the course D2L shell. This file contains data from 19 Allegheny County, Pennsylvania municipalities from the 1990 Census. There are 3 variables in the data set:

Median Income = median household income of the municipality in 1990 (current) dollars

Home Value = median value of owner-occupied housing units in the municipality in 1990 dollars

Population Density = population density of the municipality in people per square mile

a.
a priori,
do you expect there to be any relationship between any of these variables? If so explain.

b. Create 3 pair-wise scatter plots of this data (income-Home Value, Income-Density, Home Value-Density). (Cut and paste these plots below.) Do these plots align with your answer to (a)? Explain.

c. Create a bubble chart of this data, with Home Value on the vertical axis, Population Density on the horizontal axis, and Median Income represented by the size of the bubble. Label completely and consider effective design and usability in the creation of your graphic. Cut and paste this chart below. Write a short paragraph describing the graphic (like what might be found as a caption for this graphic if used in a report).

d. How effective is your graphic at illustrating any relationships that exist in this data? Explain.

## Answer To: 1. Download the Excel file “Muni Data MT1.xlsx” from the course D2L shell. This file contains data...

David answered on Nov 26 2019
a. I expect a positive relationship between median income and home value. As with higher income one is expected to buy housed of higher value. I expect a negative relationship between population density and median income. As with higher population density, the median income is expected to decrease. As distribution of income is expected to be skewed to left for a area with high population density. I expect a negative relationship between population density and home value. As with higher population density, the home value is expected to decrease.
b. Scatter plots:
An upward trend is observed in scatterplot indicating that there is positive linear relationship between home value and median income. Since points are close to each other I can say that this relationship is strong. The same is my expected findings.
A downward trend is observed in scatterplot indicating that there is negative linear relationship between population density and median income. Since points are not close to one another I can say that this relationship is weak. The same is my expected findings.
A downward trend is observed in scatterplot indicating that there is negative linear relationship...
SOLUTION.PDF