Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Eco Capitalism Carbon Money Climate Finance And Sustainable Development

Authors: Robert Guttmann

1st Edition

3319923560,3319923579

More Books

Students also viewed these Finance questions

Question

Explain how technology has changed the learning environment.

Answered: 1 week ago