Question
A regional planner employed by a public university is studying the demographics of nine counties in the eastern region of an Atlantic seaboard state. She
A regional planner employed by a public university is studying the demographics of nine counties in the eastern region of an Atlantic seaboard state. She has gathered the following data:
County | Median Income | Median Age | Coastal | ||
A | $ | 46,606 | 53.4 | 1 | |
B | 47,843 | 52.3 | 1 | ||
C | 47,038 | 54.6 | 1 | ||
D | 48,050 | 52.7 | 1 | ||
E | 31,806 | 44.4 | 0 | ||
F | 38,396 | 46.5 | 0 | ||
G | 38,350 | 46.2 | 0 | ||
H | 33,913 | 39.4 | 0 | ||
I | 33,473 | 30.5 | 1 | ||
Click here for the Excel Data File a. Is there a linear relationship between the median income and median age? (Round your answer to 3 decimal places.)
b. Which variable is the "dependent" variable?
multiple choice 1
Median Age
Median Income
c-1. Use regression analysis to determine the relationship between median income and median age. (Round your answers to 2 decimal places.)
c-2. Interpret the value of the slope in a simple regression equation. (Round your answer to 2 decimal places.)
d. Include the aspect that the county is "coastal" or not in a multiple linear regression analysis using a "dummy" variable. (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.)
e. Test each of the individual coefficients to see if they are significant. (Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required. Round your answers to 2 decimal places.)
f. Make a histogram of the residuals. Which plot is correct?
Residual plot 1 | Residual plot 2 | Residual plot 3 |
multiple choice 2
Plot 1
Plot 2
Plot 3
g. Make a scatter diagram of the residual values versus the fitted values. Which plot is correct?
Residuals vs Fits 1 | Residuals vs Fits 2 | Residuals vs Fits 3 |
multiple choice 3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started