$.$Use the Excel data analysis tools to analyze your Closing Stock Price data set for your chosen stocks. Compute the following forecasts: moving average with k$=2,3,4$ and exponential smoothing with alpha $=0\mathrm{.}1,0\mathrm{.}2,$ and $0\mathrm{.}3.$ You should therefore compute six forecasts for each of the assigned stocks. For each forecast, you should find the associated MAD and then determine which of the six forecast methods is best for each of the stocks. Your end goal is to forecast the next period in the data set $($the next trading day after your data set ends$).$