A regional planner is studying the demographics in a region of a particular state. She has gathered the following data on nine counties. CountyMedian...

A regional planner is studying the demographics in a region of a particular state. She has gathered the following data on nine counties.

CountyMedian

Income Median

AgeCoastalA$46,757 50.1 0 B48,213 49.9 0 C46,588 57.9 1 D47,586 52.5 0 E34,097 37.7 0 F30,963 45.1 1 G33,632 43.5 1 H35,971 48.2 1 I30,131 33.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.)

(Click to select)YesNo

, The correlation of Income and Median Age is .

b.Which variable is the "dependent" variable?   (Click to select)Median AgeMedian Income

c-1.Use statistical software to determine the regression equation. (Round your answers to 2 decimal places.)

  Income = + Median Age.

c-2.Interpret the value of the slope in a simple regression equation. (Round your answer to 2 decimal places.)

  For each year

(Click to select)decreaseincrease

in age, the income increases $ on average.

d.Include the aspect that the county is "coastal" or not in a multiple linear regression analysis using a "dummy" variable. Does it appear to be a significant influence on incomes? (Negative amounts should be indicated by a minus sign. Round your answers to 2 decimal places.)

  Income = + Median Age + Coastal

e.Test each of the individual coefficients to see if they are significant. (Round your answers to 2 decimal places. Negative amounts should be indicated by a minus sign. Leave no cells blank - be certain to enter "0" wherever required.)

  PredictorTP  Constant        Median Age        Coastal