Given the attached data. Answer the following questions using an initial alpha value of 0.2.

22.xlsxDownload 22.xlsx

1. Compute your forecast for period 51.

The potential answers are:

A: 6859.72 units.

B: 8513.07 units.

C: 3987.96 units.

D: 7662.63 units.

E: 6596.84 units.

2. Compute the MAD value for period 50.

The potential answers are:

A: 2187.37 units.

B: 3024.65 units.

C: 1646.73 units.

D: 4629.41 units.

E: 1748.93 units.

3. Compute standard deviation of forecast for period 51.

The potential answers are:

A: 2734.21 units.

B: 4886.22 units.

C: 2058.41 units.

D: 3780.81 units.

E: 2186.16 units.

4. Compute the best alpha value to three decimal points.

The potential answers are:

A: 0.312.

B: 0.159.

C: 0.399.

D: 0.085.

E: 0.44.

t	At
1	12875
2	13569
3	4569
4	9392
5	4182
6	2970
7	3599
8	3683
9	12264
10	5872
11	7009
12	6516
13	2925
14	9400
15	6992
16	10396
17	11944
18	10056
19	8173
20	9654
21	8901
22	2322
23	5483
24	8785
25	8375
26	2544
27	10499
28	5305
29	8094
30	10351
31	5158
32	3131
33	9929
34	13490
35	7476
36	10736
37	10124
38	6907
39	4484
40	5475
41	6488
42	2573
43	5861
44	2818
45	10048
46	10300
47	2792
48	11416
49	12108
50	5184