need a solid explanation for 6 please.

II G 4- Use Exponential smoothing forecasts with alpha of 0.1, 02-09 to predict January 2021 demand. Identify the value of alpha that results in the lowest MAD 3. Find the monthly seasonal indices for the demand values using Sample Average (SA) method. Find the de-seasonalized demand values by dividing monthly demand by seasonal indices. 6- Use regression to perform trend analyses on the de-seasonalized demand values. Is trend analysis suitable for this data? Find MAD, the seasonally adjusted trend forecasts for January through March 2021 and explain the Excel Regression outpot (trend equation, tr squared, goodness of modeli B ASUS > N U 8 M K 0 . alt O VICE A P . 93F 44 m ctr Month/Yr. Jan. 2016 Q Jan, 2017 Jan 2018 Dataset Sheet Set O type here to search PERIOD PRICE 1 54 2 55 3 4 5 2 3 6 7 B 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 201 29 31 E W 09 19 5.9 59 59 64 62 19 19 60 AIP 59 6.8 6.8 64 63 65 63 99. 6.1 66 6.0 63 09 64 63 19 19 69 63 52 60 68 68 66 09 64 61 60 61 62 6.0 SB 0.4 01 -08 -1.0 41 63 -02 162 31 0.4 7.0 05 77 03 68 68 7.1 70 67 03 65 03 61 67 55 69 5.8 60 293 US DIFF 0.5 11 0.4 00 05 60 O R 10: 10- ADV 53 68 73 05 72 43 20 50 7.3 72 65 611 50 27 58 5.5 00 82 5 65 63 83 02 84 36 89 1.0 75 78 0.0 10 94 9.1 93 94 19 H DEMAND 139 145 14.7 149 149. 14.6 14.1 120 14.2 139 123 139 138 140 145 160 6 15.7 15.8 152 15.9 162 15.0 691 17.1 169 174 172 176 184 186 174 184 Y 7 125 U fx Jan 2019 Jan 2020 Jam 2025 Dataset Sheet2 Sheet3 @ Type here to search 2 3 31 32 33 34 35 36 37 311 39 40 41 42 43 44 45 SECSEREURRESLESSE 51 E 56 62 64 72 65 5.9 62 60 67 62 69 60 63 69 19 6.8 74 73 73 72 75 67 165 70 60 7.1 61 72 72 73 72 71 69 72 73 74 75 70 09 162 59 9.9 02 98 -0.5 9.5 -0.9 10.1 -0.6 10.2 -02 10.5 -1.0 10.3 -1.0 63 -0.9 64 -08 106 65 OF 105 -12 11.6 09 10.1 10.3 10.7 6.0 164 65 59 U 6.8 69 08 89 O 80 80 90 00 50 II M 195 -10 -12 -0.9 109 -0.9 10.8 -10 11.1 08 112 115 65 68 11.6 119 6.9 70 96 26 -0.4 02 -07 75 -02 75 65 31.6 119 D 66 5 105 11.8 11.9 120 B 184 17.6 167 182 185 191 19.0 19.0 198 198 200 20.9 196 19.5 184 193 193 13 199 20.0 201 201 202 21.1 20.6 20.7 21.3 214 215 216 215 9 E 7 Jan. 2020 X 2 W Jan. 2021 Feb. 2021 Mar. 2021 t Sheet2 Sheet3 O here to search # D 38 39 3 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 22283238 LE 57 58 59 60 61 62 63 S GORENNREE 667 6.9 63 6.7 6.5 7.1 7.0 6.0 7.2 72 7.3 7.2 -0.6 10.2 -0.2 10.5 -1.0 10.3. -1.0 9.9 -0.9 10.5 -0.8 10.6 -0.8 10.5 -1.2 11.6 -0.9 10.1 -1.0 10.3 -1.2 10.7 6.4 -0.9 10.9 10.8 11.1 CAREERSRECESA 53 6.1 6.3 O 6.4 7.1 6.2 6.5 6.9 72 73 7.4 -0.9 7.5 -1.0 7.0 62 -0.8 11.2 68 68 0.0 11.6 7.4 6.9 -0.5 11.5 7.3 6.5 -0,8 11.6 7.3 6.9 -0.4 11.9 72 7.0 -0.2 11.8 75 68 -0.7 11.9 7.5 6.8 -0.7 12.0 75 65 +1.0 11.9 C 6.0 5.9 6.0 6.5 O 6.5 L K LI ECE 5 9m E3 6 19.0 19.8 19.8 20.0 20.9 19.6 19.5 18.4 19.3 19.3 19.9 20.0 20.1 20.1 20.2 21.1 20.6 20.7 21.3 21.4 21.5 21.8 21.5 17 C D 7