The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 weeks appears in table 1 below. week Demand For
Table 1. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 weeks appears in table 1 below.
week |
Demand |
Forecast |
Error |
ABS. Dev |
Squared Error |
APE |
1 |
20 |
|
|
|
|
|
2 |
28 |
|
|
|
|
|
3 |
22 |
|
|
|
|
|
4 |
18 |
|
|
|
|
|
5 |
22 |
|
|
|
|
|
6 |
22 |
|
|
|
|
|
7 |
22 |
|
|
|
|
|
8 |
26 |
|
|
|
|
|
9 |
23 |
|
|
|
|
|
10 |
23 |
|
|
|
|
|
11 |
23 |
|
|
|
|
|
12 |
27 |
|
|
|
|
|
13 |
25 |
|
|
|
|
|
14 |
22 |
|
|
|
|
|
15 |
23 |
|
|
|
|
|
16 |
14 |
|
|
|
|
|
17 |
14 |
|
|
|
|
|
18 |
15 |
|
|
|
|
|
19 |
11 |
|
|
|
|
|
20 |
16 |
|
|
|
|
|
21 |
|
|
|
|
|
|
22 |
|
|
|
|
|
|
23 |
|
|
|
|
|
|
24 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Table 1.
Create a five-week moving average and compute the followings:
a). The
b.)The mean squared error (MSE)__________________________________
c). The mean absolute percentage error (MAPE)_______________________
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 6 images