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

9

10

  yt

13

12

14

10

13

13  

8

13

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.)

t

yt

y-forecast

1   

13

2   

12

3   

14

4   

10

  

5   

13

  

6   

13

  

7   

8

  

8   

13

  

9   

14

  

10   

8

  

11   

  

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.)

  y-forecast

  

Consider the following sample data, consisting of 10 observations.

Explanation / Answer

b-2)

MSE =7.11

MAD =2.38

c)

forecast for period 11 =11.67

t yt y-forecast |Yt-Yf| (Yt-Yf)^2 1    13 2    12 3    14 4    10 13.00 3.00 9.00 5    13 12.00 1.00 1.00 6    13 12.33 0.67 0.44 7    8 12.00 4.00 16.00 8    13 11.33 1.67 2.78 9    14 11.33 2.67 7.11 10    8 11.67 3.67 13.44 11 11.67 Total 16.67 49.78 average 2.38 7.11

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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