[SOLVED] Problem 15-05 (Algorithmic) Consider the following time series data Week1 2 3 4 5 6
April 23rd, 2022
Problem 15-05 (Algorithmic) Consider the following time series data Week1 2 3 4 5 6 Value 16 12 14 13 15 14 a. Choose the correct time series plot. 20r Time Series Value 18 16 14 12 10 20r Time Series Value 18 16 12 10 Week(t) Week(t)
Expert Answer
a) Ans (i)
The graph correctly depicts the value against the week entries. There is zig-zag pattern
Don't use plagiarized sources. Get Your Custom Essay on
[SOLVED] Problem 15-05 (Algorithmic) Consider the following time series data Week1 2 3 4 5 6
From $8/Page
b) The 3 week moving average is: (M1+M2+M3)/3
Example: Week 4 = (16+12+14)/3 = 14
| Week | Value (D) | Forecast (F) | Error (D-F) | Error Abs | Error Sq |
| 1 | 16 | ||||
| 2 | 12 | ||||
| 3 | 14 | ||||
| 4 | 13 | 14.00 | (1.00) | 1.00 | 1 |
| 5 | 15 | 13.00 | 2.00 | 2.00 | 4 |
| 6 | 14 | 14.00 | – | – | – |
| 14.00 |
Week 7 forecast = 14
MSE = (1+4+0)/((3-1) = 2.5
c)
| Week | Value (D) | Forecast (F) | Error (D-F) | Error Abs | Error Sq |
| 1 | 16 | ||||
| 2 | 12 | 16.00 | |||
| 3 | 14 | 15.20 | |||
| 4 | 13 | 14.96 | (1.96) | 1.96 | 3.84 |
| 5 | 15 | 14.57 | 0.43 | 0.43 | 0.19 |
| 6 | 14 | 14.65 | (0.65) | 0.65 | 0.43 |
| 14.52 |
Week 7 forecast = 14.52
MSE = (3.84+0.19+0.43)/(3-1) = 2.23
d) Exponential smoothing forecast is better due to lower MSE. Hence, less error
consider the following time series data
