Answer everything you can going from b) to t). Need detailed and correct work completed. Regression in excel needs to be done as well.

1. You are given the following data set. It looks at seven recent graduates and their starting salaries and final GPAs. Graduate GPA Starting Salary (x1000) 3.26 33.8 2 2.60 29.8 3 3.35 33.5 4 2.86 30.4 5 3.82 36.4 6 2.21 27.6 7 3.47 35.3 a) Perform a simple linear regression by hand and find bo and bi. You MUST show your calculations. (15 points) b) Perform a simple linear regression in Excel. Check the models against each other. (10 points) c) Identify the point estimates of Bo and Bi. d) Identify SSE, s', and s. e) Identify Sol and the t-statistic for testing the significance of the slope. Show how t has been calculated by using Soi and b1. f) Using the t-statistic and appropriate rejection points, test Ho: B1 = 0 versus Ha: Bi # 0 at a = 0.05. What can you conclude about the relationship between x and y? g) Using the t-statistic and appropriate rejection points, test Ho: B1 = 0 versus Ha: Bi # 0 at a = 0.01. What can you conclude about the relationship between x and y? h) Identify the p-value for testing Ho: B1 = 0 versus Ha: B1 # 0 . Using the p-value, determine whether we can reject Ho by setting a = .10. .05, .01, and .001. What can you conclude about the relationship between x and y? Calculate the 95% C.I. for Bi . Discuss one practical application of this interval. Calculate the 99% C.I. for Bi. k ) Identify Sto and the t-statistic for testing the significance of the y-intercept. Show how t has been calculated by using Sto and bo. 1) Identify the p-value for testing Ho: P. = 0 versus Ha: Bo # 0 . Using the p-value, determine whether we can reject Ho by setting a = :10, .05, .01, and .001. What can you conclude? m) Using the data set, show how Soi has been calculated. n) Find the total variation, the unexplained variation, the explained variation, the simple coefficient of determination (1), and the simple correlation coefficient (r). Interpret r. o) Calculate the F statistic. p) Use the F stat and the appropriate rejection point to test the hypothesis at a = 0.05. What can you conclude about the relationship between x and y? q) Use the F stat and the appropriate rejection point to test the hypothesis at a = 0.01. What can you conclude about the relationship between x and y? I) Find the p-value related to F. Using the p=value, determine whether we can reject the null by setting a = .10, .05, .01, and .001. What can you conclude? s ) Construct a 95% C.I. for a mean salary when the average GPA is 3.0. 1 ) Construct a 95% P.I. for an individual salary when the average GPA is 3.0