Question: i need detailed step by step answer Q.5 It was of interest to regress variable Y on variable X and establish their relationship. The dat
i need detailed step by step answer

Q.5 It was of interest to regress variable Y on variable X and establish their relationship. The dat is tabulated below. O S No X Y 1 1.88 2 1.90 3 2.40 2.60 YOUAWN 5 2.80 6 2.78 3.20 8 8 3.00 Output of the Regression Option of Microsoft Excel is as follows: ANOVA Significance F df SS MS F (same as P-value) Regression 1 1.463 1.463 51.61 0.00037 Residual 6 0.170 0.028 Total 7 1.634 Standard Coefficients Error t Stat P-value Lower 95% Upper 95% Intercept 1.73 0.131 13.185 1.2E-05 1.409 2.051 X 0.187 0.026 7.184 0.000 0.123 0.250 Write the linear regression model. a. Find the parameters of this model. b. What do we conclude about the regression model from ANOVA Table above? c. Using the parameters found above, compute the fitted or average values at the eight settings of variable X and the error term (difference between the actual Y value and the fitted value)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
