Hello! I'm having trouble with two of my practice exam questions. I'm not sure where to start in Excel with this. I know I'm suppose to use Exponential Smoothing, but my answers are showing as incorrect.

Question 1:

Specifically for the US, create two different forecasts using exponential smoothing. Let forecast A use an exponential smoothing constant, = 0.2, and forecast B use an exponential smoothing constant, = 0.8. What is the MAD for Forecast B? Round your answer to 2 decimal place.

Question 2:

Specifically for the US, create two different forecasts using exponential smoothing. Let forecast A use an exponential smoothing constant, = 0.2, and forecast B use an exponential smoothing constant, = 0.8. Which model produces more accurate forecasts, why? Use the MAD to support your answer.

A. Forecast A because the MAD is lower.

B. Forecast B because the MAD is lower.

C. Forecast A because the MAD is higher.

D. Forecast B because the MAD is higher.

Year	U.S.	Canada	Australia	Japan	France	Germany	Italy
1	5.5	5.6	2.1	2.3	1.6	2	4.8
2	5.5	6.5	1.6	1.7	1.5	1.1	3.7
3	6.7	6.7	3.0	1.5	1.2	0.6	3.2
4	5.5	5.5	2.9	1.3	1.4	0.6	2.8
5	5.7	5.2	2.3	1.3	1.6	0.5	2.4
6	5.2	4.4	1.4	1.2	1.2	0.4	2.7
7	4.5	3.6	1.3	1.2	1.6	0.3	3.5
8	3.8	3.4	1.6	1.4	1.6	0.3	3.7
9	3.8	3.8	1.9	1.3	2.1	1.3	3.4
10	3.6	4.5	1.8	1.2	2.7	1.1	3.5
11	3.5	4.4	1.8	1.1	2.3	0.6	3.5
12	4.9	5.7	1.6	1.2	2.5	0.5	3.2
13	5.9	6.2	1.9	1.3	2.8	0.6	3.3
14	5.6	6.2	2.6	1.4	2.9	0.7	3.8
15	4.9	5.5	2.3	1.3	2.8	0.7	3.7
16	5.6	5.3	2.7	1.4	2.9	1.6	3.1
17	8.5	6.9	4.9	1.9	4.2	3.4	3.4
18	7.7	7.2	4.8	2	4.6	3.4	3.9
19	7.1	8.1	5.6	2	5.2	3.4	4.1
20	6.1	8.4	6.3	2.3	5.4	3.3	4.1
21	5.8	7.5	6.3	2.1	6.1	2.9	4.4
22	7.1	7.5	6.1	2	6.5	2.8	4.4
23	7.6	7.6	5.8	2.2	7.6	4	4.9
24	9.7	11	7.2	2.4	8.3	5.6	5.4
25	9.6	11.9	10.0	2.7	8.6	6.9	5.9
26	7.5	11.3	9.0	2.8	10	7.1	5.9
27	7.2	10.5	8.3	2.6	10.5	7.2	6
28	7	9.6	8.1	2.8	10.6	6.6	7.5
29	6.2	8.9	8.1	2.9	10.8	6.3	7.9
30	5.5	7.8	7.2	2.5	10.3	6.3	7.9
31	5.3	7.5	6.2	2.3	9.6	5.7	7.8
32	5.6	8.1	6.9	2.1	9.1	5	7
33	6.8	10.4	9.6	2.1	9.6	4.3	6.9
34	7.5	11.3	10.8	2.2	10.4	4.6	7.3
35	6.9	11.2	10.9	2.5	11.8	5.7	10.2
36	6.1	10.4	9.7	2.9	12.3	6.5	11.3
37	5.6	9.5	8.5	3.2	11.8	6.5	12
38	5.4	9.7	8.6	3.4	12.5	7.2	12.1
39	4.9	9.2	8.6	3.4	12.4	7.8	12.3
40	4.5	8.3	8.0	4.1	11.8	7.5	12.3