The file Walmart Closing Prices, contains a little more than a years worth of the daily closing
Question:
Use the following forecasting methods:
(a) Moving average forecasting with a span of 3.
(b) Exponential Smoothing with a smoothing constant α=0.5.
(c) Use a data table to give the Forecast for 10/16/2004,MAD and MSE as the smoothing constant in part ii) varies from α=0.1 to 0.6 in increments of 0.1.
Date | Close |
15-Oct-03 | 59.07 |
16-Oct-03 | 59.39 |
17-Oct-03 | 58.84 |
20-Oct-03 | 59.00 |
21-Oct-03 | 58.97 |
22-Oct-03 | 58.24 |
23-Oct-03 | 58.70 |
24-Oct-03 | 58.11 |
27-Oct-03 | 57.79 |
28-Oct-03 | 58.76 |
29-Oct-03 | 58.85 |
30-Oct-03 | 58.80 |
31-Oct-03 | 58.95 |
3-Nov-03 | 59.04 |
4-Nov-03 | 58.66 |
5-Nov-03 | 57.92 |
6-Nov-03 | 58.61 |
7-Nov-03 | 58.42 |
10-Nov-03 | 58.12 |
11-Nov-03 | 58.28 |
12-Nov-03 | 57.96 |
13-Nov-03 | 55.52 |
14-Nov-03 | 55.00 |
17-Nov-03 | 55.00 |
18-Nov-03 | 54.72 |
19-Nov-03 | 55.21 |
20-Nov-03 | 55.07 |
21-Nov-03 | 54.81 |
24-Nov-03 | 56.08 |
25-Nov-03 | 56.04 |
26-Nov-03 | 55.70 |
28-Nov-03 | 55.64 |
1-Dec-03 | 54.50 |
2-Dec-03 | 53.02 |
3-Dec-03 | 52.69 |
4-Dec-03 | 53.02 |
5-Dec-03 | 53.48 |
8-Dec-03 | 53.40 |
9-Dec-03 | 52.61 |
10-Dec-03 | 52.95 |
11-Dec-03 | 52.81 |
12-Dec-03 | 52.50 |
15-Dec-03 | 50.74 |
16-Dec-03 | 51.39 |
17-Dec-03 | 51.90 |
18-Dec-03 | 52.60 |
19-Dec-03 | 52.35 |
22-Dec-03 | 53.07 |
23-Dec-03 | 52.77 |
24-Dec-03 | 52.44 |
26-Dec-03 | 52.52 |
29-Dec-03 | 52.90 |
30-Dec-03 | 52.78 |
31-Dec-03 | 53.05 |
2-Jan-04 | 52.30 |
5-Jan-04 | 52.12 |
6-Jan-04 | 53.34 |
7-Jan-04 | 53.48 |
8-Jan-04 | 53.26 |
9-Jan-04 | 52.40 |
12-Jan-04 | 52.51 |
13-Jan-04 | 52.76 |
14-Jan-04 | 53.14 |
15-Jan-04 | 53.49 |
16-Jan-04 | 53.48 |
20-Jan-04 | 52.95 |
21-Jan-04 | 53.45 |
22-Jan-04 | 53.18 |
23-Jan-04 | 54.21 |
26-Jan-04 | 54.61 |
27-Jan-04 | 54.43 |
28-Jan-04 | 53.27 |
29-Jan-04 | 54.48 |
30-Jan-04 | 53.85 |
2-Feb-04 | 54.69 |
3-Feb-04 | 55.01 |
4-Feb-04 | 55.39 |
5-Feb-04 | 56.25 |
6-Feb-04 | 57.58 |
9-Feb-04 | 57.32 |
10-Feb-04 | 57.53 |
11-Feb-04 | 57.07 |
12-Feb-04 | 56.98 |
13-Feb-04 | 56.32 |
17-Feb-04 | 57.52 |
18-Feb-04 | 57.20 |
19-Feb-04 | 58.38 |
20-Feb-04 | 59.43 |
23-Feb-04 | 60.05 |
24-Feb-04 | 59.95 |
25-Feb-04 | 59.88 |
26-Feb-04 | 59.40 |
27-Feb-04 | 59.56 |
1-Mar-04 | 60.45 |
2-Mar-04 | 59.55 |
3-Mar-04 | 60.36 |
4-Mar-04 | 61.05 |
5-Mar-04 | 60.24 |
8-Mar-04 | 60.46 |
9-Mar-04 | 60.28 |
10-Mar-04 | 58.76 |
11-Mar-04 | 57.90 |
12-Mar-04 | 58.48 |
15-Mar-04 | 57.90 |
16-Mar-04 | 57.97 |
17-Mar-04 | 58.35 |
18-Mar-04 | 58.94 |
19-Mar-04 | 58.60 |
22-Mar-04 | 58.10 |
23-Mar-04 | 58.21 |
24-Mar-04 | 58.58 |
25-Mar-04 | 59.82 |
26-Mar-04 | 59.41 |
29-Mar-04 | 60.13 |
30-Mar-04 | 60.00 |
31-Mar-04 | 59.69 |
1-Apr-04 | 58.35 |
2-Apr-04 | 58.60 |
5-Apr-04 | 58.64 |
6-Apr-04 | 59.02 |
7-Apr-04 | 57.98 |
8-Apr-04 | 56.69 |
12-Apr-04 | 57.34 |
13-Apr-04 | 56.47 |
14-Apr-04 | 57.42 |
15-Apr-04 | 57.79 |
16-Apr-04 | 58.44 |
19-Apr-04 | 58.37 |
20-Apr-04 | 58.10 |
21-Apr-04 | 58.35 |
22-Apr-04 | 58.60 |
23-Apr-04 | 58.97 |
26-Apr-04 | 58.14 |
27-Apr-04 | 58.60 |
28-Apr-04 | 57.98 |
29-Apr-04 | 57.57 |
30-Apr-04 | 57.00 |
3-May-04 | 56.54 |
4-May-04 | 56.00 |
5-May-04 | 55.86 |
6-May-04 | 54.58 |
7-May-04 | 53.90 |
10-May-04 | 55.22 |
11-May-04 | 54.53 |
12-May-04 | 55.06 |
13-May-04 | 55.25 |
14-May-04 | 55.06 |
17-May-04 | 54.70 |
18-May-04 | 55.21 |
19-May-04 | 54.78 |
20-May-04 | 54.84 |
21-May-04 | 55.09 |
24-May-04 | 54.99 |
25-May-04 | 55.49 |
26-May-04 | 55.28 |
27-May-04 | 55.97 |
28-May-04 | 55.73 |
1-Jun-04 | 55.44 |
2-Jun-04 | 56.35 |
3-Jun-04 | 56.60 |
4-Jun-04 | 56.59 |
7-Jun-04 | 57.50 |
8-Jun-04 | 57.68 |
9-Jun-04 | 57.03 |
10-Jun-04 | 57.20 |
14-Jun-04 | 56.38 |
15-Jun-04 | 56.71 |
16-Jun-04 | 56.12 |
17-Jun-04 | 55.85 |
18-Jun-04 | 55.62 |
21-Jun-04 | 54.93 |
22-Jun-04 | 54.06 |
23-Jun-04 | 53.55 |
24-Jun-04 | 53.15 |
25-Jun-04 | 52.51 |
28-Jun-04 | 52.46 |
29-Jun-04 | 51.98 |
30-Jun-04 | 52.50 |
1-Jul-04 | 51.76 |
2-Jul-04 | 51.93 |
6-Jul-04 | 52.08 |
7-Jul-04 | 52.32 |
8-Jul-04 | 52.18 |
9-Jul-04 | 51.76 |
12-Jul-04 | 52.21 |
13-Jul-04 | 53.01 |
14-Jul-04 | 52.58 |
15-Jul-04 | 52.33 |
16-Jul-04 | 52.65 |
19-Jul-04 | 52.86 |
20-Jul-04 | 53.25 |
21-Jul-04 | 53.12 |
22-Jul-04 | 52.91 |
23-Jul-04 | 53.16 |
26-Jul-04 | 52.65 |
27-Jul-04 | 53.90 |
28-Jul-04 | 53.91 |
29-Jul-04 | 53.48 |
30-Jul-04 | 53.01 |
2-Aug-04 | 53.18 |
3-Aug-04 | 52.87 |
4-Aug-04 | 53.20 |
5-Aug-04 | 52.05 |
6-Aug-04 | 51.33 |
9-Aug-04 | 51.37 |
10-Aug-04 | 52.11 |
11-Aug-04 | 51.63 |
12-Aug-04 | 52.65 |
13-Aug-04 | 53.40 |
16-Aug-04 | 54.30 |
17-Aug-04 | 54.97 |
18-Aug-04 | 54.46 |
19-Aug-04 | 54.86 |
20-Aug-04 | 54.65 |
23-Aug-04 | 53.80 |
24-Aug-04 | 53.86 |
25-Aug-04 | 54.10 |
26-Aug-04 | 53.88 |
27-Aug-04 | 53.56 |
30-Aug-04 | 53.20 |
31-Aug-04 | 52.67 |
1-Sep-04 | 52.63 |
2-Sep-04 | 53.12 |
3-Sep-04 | 53.25 |
7-Sep-04 | 53.29 |
8-Sep-04 | 53.08 |
9-Sep-04 | 52.57 |
10-Sep-04 | 53.45 |
13-Sep-04 | 53.35 |
14-Sep-04 | 53.22 |
15-Sep-04 | 52.91 |
16-Sep-04 | 52.77 |
17-Sep-04 | 52.48 |
20-Sep-04 | 52.20 |
21-Sep-04 | 52.26 |
22-Sep-04 | 51.67 |
23-Sep-04 | 52.54 |
24-Sep-04 | 52.81 |
27-Sep-04 | 52.52 |
28-Sep-04 | 52.78 |
29-Sep-04 | 53.00 |
30-Sep-04 | 53.20 |
1-Oct-04 | 53.13 |
4-Oct-04 | 53.31 |
5-Oct-04 | 53.41 |
6-Oct-04 | 53.98 |
7-Oct-04 | 53.55 |
8-Oct-04 | 52.85 |
11-Oct-04 | 52.90 |
12-Oct-04 | 52.92 |
13-Oct-04 | 52.55 |
14-Oct-04 | 52.10 |
15-Oct-04 | 52.53 |
Essential University Physics
ISBN: 978-0321976420
3rd Edition Volume 2
Authors: Richard Wolfsonby, Richard Wolfson