Descriptive Statistics help with the explanation

Wage EDUC EXPER AGE 37.85 11 2 40 21.72 1 39 14.34 2 38 21.26 53 24.65 6 15 59 25.65 12 36 15.45 45 20.39 4 12 37 29.13 in 14 37 27.33 11 3 43 18.02 5 32 20.39 18 40 24.18 1 49 17.29 4 10 43 15.61 1 31 35.07 22 45 40.33 11 3 31 20.39 4 14 55 16.61 5 30 16.33 3 28 23.15 6 15 60 20.39 13 32 14 88 58 13.88 4 28 17.65 40 15.45 2 37 26.35 18 52 19.15 44 16.61 6 57 18.39 30 15.45 H 43 18.02 31 13.44 3 33 17.66 6 23 51 16.96 15 3.7 14.34 4 9 45 15.45 5 3 55 17.43 in 14 57 35.89 16 36 20.39 4 20 60 11.81 4 5 35 15.45 10 34 17.66 5 4 28 13.87 1 25 16.35 7 10 43 15.45 2 42 23.67 4 17 47 16.02 11 2 46 23.15 4 15 52 24.18 11 64(5 points)_Regression In a regression analysis the Total Sum of Squares is SST = 2000 and the Sum of Squares due to Error (residuals) is SSE = 800. a) What is the numerical value of the Coefficient of Determination, R2 2 Show calculations. b) What additional information would you need to calculate the Adjusted Coefficient of Determination, Adjusted R??16] (18 points} Hourly Wage A researcher interviews 50 employees of a large manufacturer and collects data on each worker's hourly wage (WAGE), years of higher education {EDUC}, years of experience {EXPER} and age {AGE} The data are on the sheet Hourly Wage in the data workbook. a} Use Excel to nd the estimated linear regression models for WAGE using the following three dJoiceLfor. the predictor variables: ii} EDUC and EXPER iii} All three: EDUC, EXPER and AGE b} For your third model MAGE " EDUC, EXPER 8: Elgarell carefully the slope coefficient for EDUC c} Which model provides the best t for WAGE? Justify your response an W-t measure {as calculated by Excel} d} Travis is W has 5 years of higher education and 8 yea rs of experience. He has just been offered a job at an hourly rate of 537. Does that seem reasonable, compared with the other employees? Use the model you chose in c} tojustify your