MIS 301.001 Spring 2023 Assignment 4: Time-Series Analysis and Forecasting Total points: 10 X 4 = 40 Due date: April 5, 2023, by 11:59 PM The Excel file data.xlsx contains time-series values for 8 consecutive weeks. The variables are: Week: The serial number of a week. Value: The time-series value observed for a week. Use an Excel file with the following computations - 1. Using the nave method compute the following: a. Forecast for the next week (week 2 - week 8) b. Mean forecast error c. Mean absolute error d. Mean squared error e. Mean percentage error f. Mean absolute percentage error 2. Using the average of all the historical data compute the following: a. Forecast for the next week (week 2 - week 8) b. Mean forecast error c. Mean absolute error d. Mean squared error e. Mean percentage error f. Mean absolute percentage error 3. Using the moving average method (k=2) compute the following: a. Forecast for the next week (week 3 - week 8) b. Mean forecast error c. Mean absolute error d. Mean squared error e. Mean percentage error f. Mean absolute percentage error 4. Using the exponential smoothing method (=0.8) compute the following: a. Forecast for the next week (week 2 - week 8) b. Mean forecast error c. Mean absolute error d. Mean squared error e. Mean percentage error f. Mean absolute percentage error

Submission Instructions: Use Excel to conduct the time-series analyses. Use a different spreadsheet for each of the four

Here are the data for it

Week	Value
1	18
2	13
3	16
4	11
5	17
6	14
7	17
8	13