The file Walmart Closing Prices, contains a little more than a years worth of the daily closing

Fantastic news! We've Found the answer you've been seeking!

Question:

The file Walmart Closing Prices, contains a little more than a year’s worth of the daily closing values of Walmart’s stock from 2003 and 2004. Use this data to develop a forecast for the day following the end of the data (October 16 2004.)

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