Closing Stock Prices which provides data for IBM stock over a 1-month period complete in Excel Forecast
Question:
Closing Stock Priceswhich provides data for IBM stock over a 1-month period complete in Excel
Forecast IBM stock prices using 2-period moving average
Forecast IBM stock prices using exponential smoothing with = 0.3
Calculate MAE, MSE and MAPE for both 2-period moving average and exponential smoothing with = 0.3
Using MAE, MSE, MAPE as guidance, which forecasting approach is better in this case?
Closing Stock Prices
Date IBM
9/3/2010 $127.58
9/7/2010 $125.95
9/8/2010 $126.08
9/9/2010 $126.36
9/10/2010 $127.99
9/13/2010 $129.61
9/14/2010 $128.85
9/15/2010 $129.43
9/16/2010 $129.67
9/17/2010 $130.19
9/20/2010 $131.79
9/21/2010 $131.98
9/22/2010 $132.57
9/23/2010 $131.67
9/24/2010 $134.11
9/27/2010 $134.65
9/28/2010 $134.89
9/29/2010 $135.48
9/30/2010 $134.14
10/1/2010 $135.64