Consider the following sample data, consisting of 10 observations t 1 2 3 4 5 6

Question

Consider the following sample data, consisting of 10 observations t 1 2 3 4 5 6 7 8 910 yt 12 6 7 13 11 8 11 10 14 8 Click here for the Excel Data File b-1. Construct a 3-period moving average and use it to make forecasts. (Round your answers to 2 decimal places.) y-forecast 4 13 10 14 10 b-2. Compute the resulting MSE and MAD. (Do not round intermediate calculations. Round your answers to 2 decimal places.) MSE MAD c. Make a forecast for period 11. (Round your answer to 2 decimal places.) forecast

Explanation / Answer

from above below is forecast table:

b-2) MSE =9.29

MAD =2.52

c) forecast for 11th period =10.67

t y (A) forecast(F) |A-F| (A-F)^2 1 12 2 6 3 7 4 13 8.33 4.67 21.78 5 11 8.67 2.33 5.44 6 8 10.33 2.33 5.44 7 11 10.67 0.33 0.11 8 10 10.00 0.00 0.00 9 14 9.67 4.33 18.78 10 8 11.67 3.67 13.44 11 10.67 total 17.67 65.00 average 2.52 9.29

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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