I am stuck on problem #8. Can you please work the problem so I can double check my work?

March 2020 8c) Derive the value of 59. First you must find all five values of 7tby hand by using the values of Xi in your prediction equation. 8d) Using a two tailed t test of Hypotheses, test the slope for significance at a = 0.06. Find the critical value of t, and compare it to the calculated value of t and come to the appropriate conclusion. (Note, the value of Z (Xi w?)2 is given on the rst page). Also nd the p value associated with your computed t. Ho: Bl: 0 Ha: 31$ 0 8e. Now Find the unadjusted value of r2, and tell me what that value means. 8f. Derive the ANOVA table associated with this regression March 2020 hypothesis. (check with computer) Do this by hand, Also, tell me what the Null hypothesis is associated with this ANOVA table and test that Hypothesis at alpha = 0.06 using the F test. State your conclusion. ANOVA Table Associated With Simple Linear Regression Source Sum of squares D.F Mean Square F Critical F Regression Residual Total Ho: Ha: March 2020 8. An individual wants to determine the linear relationship between the hours of training (the variable X in sales techniques) and the number of sales(Y). The following five observations were collected at random. You must do the entire 1 problem by hand, but you may (and should) check all your answers using excel. X Y XY X2 K- (Yi_?i)2 G's-702 (XI-XV 1) 4 15 so 15 11 35 1 2) 1 5 5 1 16 4 3) 4 7 28 16 4 1 4) 3 1o 30 9 1 o 5) 3 8 24 9 0 15 45 147 51 44 6 8a)By hand, and by using the least squares normal equations that I used in class, come up with the values of b0 and b1 in the equation % = be + blxi ?=1Yi = nbo + b1 ?=1Xi Z1=1X1Yi = b0 Z?=1Xl + b]. ?=1Xi2 8b) The normal equations are derived in simple linear regression or in multiple regression with the very same goal in mind. What is that goal? Be specific