A-Create new Excel file. On sheet1, in column A starting in row 5 type the values 1 through 20 to represent time periods 1 to 20. In the corresponding cells in column B simulate 20 periods of data using the equation 10 + (2*rand()).

B-copy sheet1 to a new sheet and use the special paste function to put your simulated values from sheet1 to the new sheet.

C-create forecasts for the data using the 2 period moving average method, the 3 period moving average method, exponential

smoothing with a smoothing constant of .1, and exponential smoothing with a constant of .9.

D-Calculate the MSE for each of the 4 forecast methods you created at step C.

E- Based on MSE, which forecast method is preferable for this data over the timeframe of the 20 periods?

F-turn in your Excel file.