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

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: 5790.25 units.

B: 11563.8 units.

C: 8176.5 units.

D: 4507.63 units.

E: 6368.75 units.

2. Compute the MAD value for period 50.

The potential answers are:

A: 3328.68 units.

B: 4816.61 units.

C: 3579.03 units.

D: 1900.86 units.

E: 2819.37 units.

3. Compute standard deviation of forecast for period 51.

The potential answers are:

A: 5185 units.

B: 6021 units.

C: 4474 units.

D: 2376 units.

E: 4161 units.

4. Compute the TS value for period 50.

The potential answers are:

A: -4.7.

B: 2.3.

C: -0.6.

D: -2.

E: 2.8.

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

A: 24540365 units.

B: 33664294 units.

C: 15948260 units.

D: 4652258 units.

E: 11360215 units.

6. Compute the standard deviation of demand for period 51 using MSE.

The potential answers are:

A: 3994 units.

B: 5802 units.

C: 4083 units.

D: 2157 units.

E: 3370 units.

Please give a formula if any

here is the data needed to solve

1	6780
2	2847
3	9116
4	11607
5	3660
6	16150
7	3312
8	11303
9	9898
10	7604
11	5874
12	8828
13	6014
14	9014
15	4860
16	4047
17	10699
18	11710
19	9119
20	8175
21	10175
22	4801
23	16197
24	4054
25	11379
26	14073
27	10616
28	2195
29	8173
30	2627
31	9611
32	11848
33	10226
34	4942
35	7565
36	11565
37	10215
38	3886
39	3205
40	9700
41	4573
42	7060
43	7282
44	7415
45	10835
46	11800
47	2686
48	9434
49	6230
50	4811