Analysis Of Variance Ta Source Regression Line Time2 Quarter 1 Quarter 2 Quarter 3 Error Total De Adj 99 Adj Ms 5 361967 1 (99.21 KiB) Viewed 78 times
Analysis Of Variance Ta Source Regression Line Time2 Quarter 1 Quarter 2 Quarter 3 Error Total De Adj 99 Adj Ms 5 361967 2 (107.15 KiB) Viewed 78 times
Analysis of variance ta Source Regression Line time2 quarter 1 quarter 2 quarter 3 Error Total DE Adj 99 Adj MS 5 361967 72393 1 17638 17638 1 51456 51456 1 21116 21116 1 7143 1 01343 01343 34 124336 365/1 39 486303 F-Value 19.90 4.82 14.07 5.86 1.95 22.24 P-Value 0.000 0.035 0.001 0.021 0.171 0.000 7143 Model Sur S HR-5(adt) 60.4726 74.430 70.679 Haq (pred) 65.416 VIE Coefficients Torn Coor SE Cool Constant 276. 35.0 Ετα -7.46 3.10 timo2 0.3012 0.0003 quarter 2 65.8 27.2 quarter 2 37.9 27.1 quarter_3 -127.6 27.1 T-Value 7.89 -2.20 3.75 2.42 1.10 -4.72 P-Value 0.000 0.035 0.001 0.021 0.171 0.000 16.81 16.00 Reside Plass for y 1.51 Venus R 1.51 1.50 M Regression Equation y = 276.6 - 7.46 time + 0.3012 time2 + 65.8 quarter 1 - 37.9 quarter_2 - 127.6 quarter_3 Ve Order .... 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
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 statistic 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 Analysis of variance Time Senes Plot of y Sourco Rogrossion Line time2 quarter 1 quarter 2 quarters Error Total DF Adj ss Adj MS E-Valuo 5 361967 72393 19.80 2 17638 17638 4.82 1 51456 51450 14.07 1 21116 21116 5.86 1 7143 7143 1.95 1 31343 81343 22.24 34 124336 36571 39 486303 P-Valuo 0.000 0.035 0.001 0.021 0.171 0,000 Model Surinary 9 R-a R-39(adj) 60.4726 74.433 70.670 R-a (pred) 65.416 G 40 20 Indes Conrricienta Torna Coot Cons Lane 276.6 time -7.16 timo2 0.3012 quarter 2 65.8 inter 2 379 SE Coat T-Value P-Value VIE 35.0 7.89 0.000 3.40 -2.20 0.035 16.81 0.0003 0.001 16.00 27.2 2.42 0.021 1.51 27.1 1.4 n. 121 1.51 3.75 Residual Plots for y
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!