Question

Help with 4-9 please? Thanks!

& Lake 23 8 1052 105.1 County Population (1) Elevation (X) Longitude (X) Obama (1) Prediction Squared Error Broomfield 5269 105.1 Gilpin 9141 105.5 Denver 620 5245 104.9 11580 106.3 San Juan 10791 107.7 Clear Creek 9 9676 105.7 10.18 Ouray 10236 107.8 Sedgwick 2 3802 102.4 Teller 9150 Summit 10959 61.0 Above is a table of the 2012 presidential election results for Colorado counties. I ran a regression to find out whether population (in 1000s), elevation (in feet), and longitude predict anything about the percentage of people voting for Obama. My results were b -173, population - 0.053, belevation - 0.0018, bongitude1.95. 1. Write the regression equation, using the regression coefficients given above. =-173 +0.053(population) +0.0018(elevation) + 1.95(longitude) 2-3. Fill in the table columns for prediction and squared error. 4. Calculate the residual sum of squares. Sresidual 5. Calculate the total sum of squares of the outcome Y. Stotal 6. Calculate the sum of squares explained by the regression Sregression 7. What proportion of the total variability does the regression explain? R- 8-9. Convert the regression and residual sums of squares to mean squares. The degrees of freedom are dression=m 3 and dre -m-16 . MS egression MS residual

Answer 1

• Please check attachment

ܠܠ : Sum residual d squaled error = I'ms quared errore Sresidual = 52.56 +52.6570.137 24.01 +15.15+10.18718.8975.43 T 314.32 + 34.75 = 528.07 Answer

ELTEMTIT sto mae -363-52.5-j = 60-8) + (4-2)} +(21-097(7.9) 7 (0.1+(1-7)7 (-1.032 +(-21-23 +(-20.45$+(8.50j? = 463.44 Answer CO S Stotal = SS residual + ss regression so s Svegression = sStorad - SS sesidual = 1 463.44 - 528.07 -935.37 0.639 Rz Ssreqsession935.37 - 1463.44 Sstoral 939,372 311.79 MS regression? SS regremien afsegression SS residual - 528.07 z 88-01 potrestand saison = 5901 88.02 MS residual doesidual