1. Using the following table of relation between X & Y (Y is the independent Variable): Xi 0 2 4 3 6 7 8 9 Vi 5 8 2 3 20 30 a. Find the estimated regression equation. Show ALL your calculations and the appropriate formula. WRITE Formula in all the questions below and substitute for the numbers, demonstrate your work. b. Calculate R2. Comment on the Goodness of the Fit. Is it a good fit? Why? C. Test the hypothesis regarding the significance of the slope Bi. (Use a = 0.05) Show ALL the calculations necessary to get your answer. d. Calculate the values of F, using formula for F statistics. e. Draw the scatter diagram and also your estimated regression line. Part B): Perform the Simple Regression in Excel and Submit the Summary Output along with your response