Reference no: EM131240232
1. Download the Excel file "Muni Data.xlsx".
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). 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. 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.
Attachment:- Muni-Data-.rar
|
What is the maximum pressure on her hand
: what is the maximum pressure on her hand? What would be the maximum pressure if the "car" were an Indy 500 racer traveling 200 mph?
|
|
What is difference between perpetual and periodic inventory
: What is the difference between perpetual and periodic inventory? Give some examples. Gross Profit-Merchandise is sold for $615,000 cash and 4,110,000 on account.
|
|
Determine the volumetric flow rate through the bend
: Determine the volumetric flow rate through the bend and the y direction anchoring force, FAy, required to hold the bend in place. The flow is not frictionless.
|
|
What wireless network modules are available
: . What wireless network modules are available in ns-3? Consider Data Link Layer (i.e. MAC protocol modules) and Network Layer (i.e. routing protocol modules). In what directories are they located?
|
|
Create a bubble chart of given data
: 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.
|
|
Explain what impact change in currency exchange rate have
: Assume that the plant produced and sold product in the local economy. Explain what impact this change in the currency exchange rate would have on the project's internal rate of return.
|
|
What is the gage pressure at a stagnation point
: What is the gage pressure at a stagnation point on the structure if it is at sea level where the air density is 1.23 kg/m3 ?
|
|
Explore the stanford prison experiment website
: Select at least two (2) research methods from the text (e.g., observations, case studies, experiments, etc.), and explain each method's purpose in social psychology. Next, identify at least one (1) situation in which you could apply one (1) of the..
|
|
Create a function
: Create a function. The creation of a function is an iterative process. The first step of that process (explained in #3 below) is to get the code working as standard R code with all of the values hard coded
|