(Solved): A regional planner employed by a public university is studying the demographics of nine counties in ...

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: 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? 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. Leav no cells blank - be certain to enter " 0 " wherever required. Round your answers to 2 decimal places.)