Question: Please show formulas used in excel please Question 2 (You can use EXCEL to solve this): 30 points Use the following data for parts (a)
Please show formulas used in excel please

Question 2 (You can use EXCEL to solve this): 30 points Use the following data for parts (a) through (f). x 5 7 3 16 12 9 y 8 9 11 27 15 13 a. Determine the equation of the least squares regression line to predict y by x. b. Using the x values, solve for the predicted values of y and the residuals. c. Solve for se. d. Solve for me. e. Test (Hypothesis testing) the slope of the regression line. Use a = .01. f. Comment on the results determined in parts (b) through (e), and make a statement about the fit of the line
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
