Please show me the excel formula and data solve(r)/(w)hat-if analysis:QuestionProblem 1: The file Walmart Closing Prices, contains a little more than a years worth of the daily closing values of Walmarts stock from 2003 and 2004. Use this data to develop a forecast for the day following the end of the data (October 162004.)Use the following forecasting methods:(a) Moving average forecasting with a span of 3.(b) Exponential Smoothing with a smoothing constant \alpha =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