compute in excel please

1. Complete this question in the worksheet entitled 'Q1.' (a) Make naive forecasts in Column C, then errors in Column D, squared errors in E, and percent errors in F. (b) Make a modified naive prediction in Column G. Examine the seasonality of the data to determine how many previous periods to use. (c) Calculate the errors for Column H, the squared errors in Column I, and the percent errors in Column J. (d) Place the MSE and RMSE in the highlighted cells. Which is the best forecast? 1. Complete this question in the worksheet entitled 'Q1.' (a) Make naive forecasts in Column C, then errors in Column D, squared errors in E, and percent errors in F. (b) Make a modified naive prediction in Column G. Examine the seasonality of the data to determine how many previous periods to use. (c) Calculate the errors for Column H, the squared errors in Column I, and the percent errors in Column J. (d) Place the MSE and RMSE in the highlighted cells. Which is the best forecast