HI, PLEASE HELP ME SOLVE THIS STEP BY STEP IN EXCEL, THANK YOU SO MUCH IN ADVANCE

Consider the following time series data:

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

Calculate a two-week moving average for the data.

What is the MSE for the problem? (The number)

Use = 0.2 to compute the exponential smoothing values for the time series.

Compute MSE from the exponential smoothing method.

Based on MSE, which method of forecasting seems to be better with this data?

The Port of Savannah is considering an expansion of its container terminal. The port has experienced the following container throughput during the past 12 years (based on a standard unit of measure that need not concern us here):

Year amount

1 526.1

2 549.4

3 606.0

4 627.0

5 695.7

6 734.9

7 761.1

8 845.4

9 1021.1

10 1137.1

11 1173.6

12 1233.4

What is the linear trend forecast line?

What is your forecast for period 10 based on the linear trend forecast line?