Given the attached data. Answer the following questions for a 5 period moving average.

03.xlsxDownload 03.xlsx

MAD = Average(|A-F|)

TS =SUM(A-F)/MAD

MSE = Average(A-F)²

1. Compute your forecast for period 51.

The potential answers are:

A: 12461

B: 11221.6

C: 4414

D: 10290.67

E: 8041.75

2. Compute the MAD value for period 50.

The potential answers are:

A: 3999.02

B: 3732.56

C: 3760.99

D: 3753.86

E: 3892.54

3. Compute the TS value for period 50.

The potential answers are:

A: -1.7.

B: 4.1.

C: -5.8.

D: 2.5.

E: 0.

4. Compute the MSE value for period 50. The potential answers are:

A: 24529308

B: 20380735

C: 18146974

D: 18872575

E: 21687584

t	At
1	9040
2	11723
3	4071
4	1580
5	4885
6	13455
7	12017
8	7363
9	15719
10	8916
11	7262
12	3285
13	5628
14	5953
15	13027
16	4474
17	14904
18	3797
19	10939
20	6995
21	9801
22	5195
23	4921
24	9370
25	12263
26	7340
27	4953
28	3663
29	10780
30	5107
31	13235
32	8729
33	2848
34	6829
35	2516
36	12743
37	9554
38	3185
39	5215
40	2260
41	4424
42	6266
43	9514
44	10499
45	3575
46	12365
47	13765
48	13675
49	9390
50	6913