Perform the following in Excel:
(1) Using the estimated regression equation to compute Y-hat for all observations. Keep 4 or 5 decimal places to reduce rounding errors.
(2) Compute residuals for all observations.
(3) Compute SST, SSR, and SSE to reproduce the ANOVA table in excel output.
(4) Using the above results to reproduce the "Summary Statistics" in excel output, namely, R-square, adjusted R-square, Multiple R
PLACE AN ORDER TODAY & GET 15% DISCOUNT (CODE GAC 15)