DCS 2500 2000 1000 DCS Forecast of DCS Fitted Values Multiple Regression Result

Question

DCS 2500 2000 1000 DCS Forecast of DCS Fitted Values Multiple Regression Result Formula DCS = 3.266.66 + ( (DC SP)"-0.098297 ) + ( (PR)"-21.17 ) + ( (Q2) . 292.88 ) + ( (Q3)" 149.07 ) + ( (04)"-60.25 ) Audit Trail -ANOVA Table (Multiple Regression Selected) Source of Variation Regression Error Total df SEE MS 366,836.05 1,834,180.23 34 14,544.31 120.60 494,506.47 2.328,686.70 Audit Trail Coefficient Table (Multiple Regression Selected) Overall F-test Series Descritpion DCS DCSP PR Q2 03 04 Included in Model Standard Error Coefficient T-test P-value F-test Elastic 128.56 51.50 11.34 25.22 Dependent Yes Yes Yes Yes Yes 0.00 0.00 288.10 0.10 21.17 292.88 149.07 60.25 0.76 13.77 54.11 54.22 5.42 2.76 1.11 0.00 0.01 0.27 29.39 7.59 1.23 Audit Trail Statistics Accuracy Measures AIC Mean Absolute Percentage Error (MAPE) R-Square Adjusted R-Square Root Mean Square Error Value 492.41 494.10 5.30% 78.76% 75.64% 111.19 Forecast Statistics Durbin Watson Mean Standard Deviation Max Min Range Value 1.62 1,802.86 244.36 2,272.60 1,421.30 851.30

Explanation / Answer

Given:

Above table is the extracted from "Audit Trail - Coefficient Table (Multiple Regression Selected)

The above table shows the p-value for DCSP, Q2 and Q3 are less than 0.05, Hence, we can conclude that these 3 factors are statistically significant. Hence, the answer is

Those that pass are DCSP, Q2, and Q3.

Variables p-value DCSP 0.00 PR 0.13 Q2 0.00 Q3 0.01 Q4 0.27

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.