Question

A regional planner is studying the demographics in a region of a particular province. She has gathered the following data on nine counties. Population > 400 000 Median County Income ($) $33626 39856 42234 44508 41311 43614 41414 43046 44150 Median Age 34.2 60.5 60.5 59.8 60.3 34.8 35.3 34.2 30.6 a. Is there a linear relationship between the median income and median age? (Round the final answer to 3 decimal places.) No , the coefficient of correlation of Income and Median Age is . b. Which variable is the "dependent" variable? Median Income C-1. Use statistical software to determine the regression equation. (Round the final answers to the nearest whole number.) Income =D + D Median Age. c-2. Interpret the value of the slope in a simple regression equation. For each year (Click to select) in age, the income increases $ on average. d. Include the aspect that the population of the county is greater than 400,000 or not in a multiple linear regression analysis using a "dummy" variable. Does it appear to be a significant influence on incomes? (Round the final answers to the nearest whole number.) Income O D Median Age + Population

Answer 1

E F G H I J K L M 1 NZ - fixe А в country Median income Median Age Population >400000 A 33626 34.2 B 39856 60.5 42234 60.5 44508 59.8 41311 60.3 43614 34.8 41414 35.3 43046 34.2 44150 30.6 5 D Median Age 0 10000 20000 30000 40000 50000 Median Income a = From the Given Scatter plot we observe that there is no liniear Realtionship between Median Age And Median Income = 0.098 Correlation between Median Income And Median Age is = 0.098 b = Median Income is the dependent variable.

B D E F G H I J K 1 SUMMARY OUTPUT Regression Statistics 4 Multiple R 0.098977352 5 R Square 0.009796516 6 Adjusted R Square -0.131661124 7 Standard Error 3532.352294 8 Observations 12 13 Intercept 14 Median Age Coefficients Standard Error Stat P-value 40459.29555 4231.108255 9.562339962 2.87133E-05 23.46499289 89.16569554 0.263161665 0.800003847 16 The regression Equation is Income = 40459.30 + 23.47* median Age Slope = 23.47 As 1 Unit increases in the value of the variable median Age there is 23.47 unit increase in the median Income.

H Α. 3 Regression Statistics 4 Multiple R 0.190606645 5 R Square 0.036330893 6 Adjusted R Square -0.284892142 7 Standard Error 3763.909295 8 Observations 9 10 e1 11 12 13 Intercept 14 X Variable 1 15 X Variable 2 16 17 Coefficients Standard Error Stat P-value 41294.31154 4954.467363 8.334763 0.000161959 17.78812908 96.03185971 0.185232 0.859150337 -1037.298881 2552.041929 -0.40646 0.698506216 The Regression Equation is, Median Income = 41294.31 +17.78 * Median Age - 1037.29 * Population > 400000 e2 From the above table we observe that none of the variable is Significant. Because the P value of both variable is greater than 0.05. Hence None of the Variable is Significant.