Given the following weighted time series, and using your knowledge of forecasting, compute, (a) the three-period weighted moving average, (b) the error of your forecasting, (c) the absolute error, (d) the squared error, (e) the absolute percentage error, (f) using a four-period moving average with arbitrary weights adding to one, repeat steps (a) thru (e), (g) and find the weights that minimize the Mean Absolute Percentage Error as shown in class. (Hint: Assume that the sum of the weights equals one in part (g)).

Please solve it correctly using Excel. Thank you!

Period	Actual Value	Weights
1	14	3
2	12	2
3	16	1
4	14
5	18
6	15
7	19
8	16
9	20
10	17
11	22
12	19