please use data from question 1 to answer question 2. please use excwl and show the printout of input and output as explained. i will rate, thank you

1. Suppose we have the following information on the examination scores and weekly employment hours of eight students: Employment Hours (X) Examination Score (Y) 5 oo nna 21 40 70 70 58 85 65 50 80 90 0 Assuming Exam Score is the dependent variable (Y) and Employment Hours is the independent variable (X), calculate the simple linear regression equation by hand. Using this, test to see whether the slope on X is significant at the 0.05 level (do this by hand, as well) using all three tests discussed. Again, this must be complete and performed by hand. What is the value of the coefficient of determination? Is this a good or bad model? (30 points) 2. Using the data for Question 1, determine the simple linear regression equation using Excel (include a printout of the output). Using p-values, comment on the goodness of fit for this regression model. This, of course, allows you to check your answers for Question 1. (10 points) 1. Suppose we have the following information on the examination scores and weekly employment hours of eight students: Employment Hours (X) Examination Score (Y) 5 oo nna 21 40 70 70 58 85 65 50 80 90 0 Assuming Exam Score is the dependent variable (Y) and Employment Hours is the independent variable (X), calculate the simple linear regression equation by hand. Using this, test to see whether the slope on X is significant at the 0.05 level (do this by hand, as well) using all three tests discussed. Again, this must be complete and performed by hand. What is the value of the coefficient of determination? Is this a good or bad model? (30 points) 2. Using the data for Question 1, determine the simple linear regression equation using Excel (include a printout of the output). Using p-values, comment on the goodness of fit for this regression model. This, of course, allows you to check your answers for Question 1. (10 points)