emergency please answer!! all one question!!! use excel! will give thumbs if answered completely!

Moving averages are often used to reflect changes in share prices. Daily closing prices in dollars per share for SanDisk for Aug 16, 2002 to September 3, 2002 are given below Date $ Price Date $ Price Date $ Price 8/16 14.45 8/22 17.32 8/28 15.09 8/19 15.75 8/23 15.96 8/29 16.42 8/20 16.45 8/26 16.45 8/30 16.21 8/21 17.4 8/27 15.6 9/3 15.22 Use a five-day moving average. The closing price for September 4, 2002 is: Use a 4-point moving average to forecast the price on September 4th 2002? Use exponential smoothing with alpha = 0.7 to forecast the price on Sept 4th 2002. The MSE (mean squared error) for the 5 point moving average is The mean squared error for exponential smoothing is The Mean squared error (MSE) for the 4 pt moving average is of the three approaches which do you prefer? O a. exponential smoothing (alpha=0.7) O b.4 point moving average O c. 5 point moving average O d. none Why do you prefer this method? O Because the forecast is highest. Because the error is lowest. O Because the MSE is largest. Because it is easy to use