Problem 1: The file Walmart Closing Prices, posted on Angel 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:
i) Moving average forecasting with a span of 3.
ii) Exponential Smoothing with a smoothing constant α=0.5.
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.
Attachment:- Data.xlsx