solve the following using excel.

show work please need to study it

1. Consider the following time series data: Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error b. What is the forecast for week 7 ? 2. Refer to the time series data in Problem 1. Using the average of all the historical data as a forecast for the next period, compute the following measures of forecast accuracy: a. Mean absolute percentage error b. What is the forecast for week 7