Question 6 14 points Save Answer Data are quarterly energy bills for a school system. The energy bills are combined gas,

[answerhappygod]

Question 6 14 Points Save Answer Data Are Quarterly Energy Bills For A School System The Energy Bills Are Combined Gas 1 (60.3 KiB) Viewed 35 times

Question 6 14 Points Save Answer Data Are Quarterly Energy Bills For A School System The Energy Bills Are Combined Gas 2 (99.52 KiB) Viewed 35 times

Question 6 14 points Save Answer Data are quarterly energy bills for a school system. The energy bills are combined gas, oil and electric bills for the school system and are expressed in units of 100$. A regression model was used for the energy bills dataset. Test for the overall significance of the model (use output below). Test statistics and p-value= Conclusion in context: since the p-value is (less/greater) than to reject Ho); that is there is/is not) least one significant term in the regression model. , we (reject Ho/fail

t) least one significant term in the regression model. Analysis of variance Source Dr Adj 33 Ady MS -value P-Valua Regrossion 5 361967 72393 19.90 0.000 Lime 1 17638 17638 4.82 0.035 time2 1 51456 51450 14.07 0.001 quarter 1 1 21116 21146 5.86 0.021 uarter 2 1 7143 7143 1.95 0.171 quarter_3 2 81343 01343 22.24 0.000 Error 34 124336 3657 Total 39 486303 Model Summary S R-q R-aq(adj) R-sq (pred) 60.4726 74.430 70.679 65.418 Confticiants Torm Coot SE Coot T-Value P-Valuo VIE ConsLant 276.6 35.0 7.89 0.000 time -7.16 3.40 -2.20 0.035 16.81 timo2 0.3012 0.0003 3.75 0.001 16.00 quarter_1 65.8 27.2 0.021 1.51 quarter 2 37.9 27.1 0.171 1.51 quarter_3 -127.6 27.1 -4.72 0.000 1.50 2.42 1.10 Regression Equation y = 276.6 - 7.46 time + 0.3012 time2 + 65.8 quarter_1 - 37.9 quarter_2 - 127.6 quarter_3 Fits and Diagnostics for Unusual Observations Std Obs y Fit Resid Resid 24 426.4 271.1 155.3 2.75 R 25 467.1 344.2 122.8 2.18 R R Large residual