Consider the following sample data, consisting of 10 observations. t 1 2 3 4 5 6
ID: 3051649 • Letter: C
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