Solve

Coefficients Std error Intercept 6356.07 838.701 X, 0.56038 0.15811 X, -31.2077 8.95905 X, -327.503 149.169 X, -113.895 16.2604 X, -621.485 147.828 S.V df Ss Ms f Regression 5 ? 72 Residual ? 2166000 ? Total 23 14370000 2.A manager selects a representative sample of 24 monthly customer bills taken from several recent heating seasons. The manager considers kilowatt hours per month (y) as a linear function of square feet heated space (x,), an index of roof insulation quality (x,), presence/absence of insulated windows (x;), mean temperature (x,) and heat pump/electric forced air (x;). The SPSS output is as following T P value 4.58 0.000 3.54 0.0023 -3.48 0.0027 -7 0.0000 -4.2 0.0005 ANOVA table a. Fit a multiple regression equation. b. Compute the standard error of the estimate and interpret it. c. Compute coefficient of determination and interpret it. d. Test the significance of the estimated regression coefficient of X, at the 5% significance level. e. Given that X,=129, X,=18, X,=5, X,=3 and X=1129, compute the 95% approximate prediction interval. f Set up the null and alternative hypothesis carry out F test and interpret your result