please solve theses questions by excel

1 2 3 17 18 189 6 261 131 24 190 The data in the following table show the daily sales of paperback books and hardcover books at the same store. The task is to forecast the next four days' sales for paperbacks and hardcover books. Day Paperbacks Hardcovers Day Paperbacks Hardcovers 199 139 16 243 240 172 128 225 111 172 167 222 4 209 139 19 237 158 5 161 191 20 202 178 119 168 21 186 217 7 195 170 22 176 8 195 145 23 232 238 9 184 195 240 10 183 135 25 214 11 143 218 26 182 200 12 141 198 222 201 13 230 28 217 283 14 222 29 188 220 15 155 206 30 247 259 (a) Using four-month moving average method compute the measures of forecasting accuracy over the test periods 11-30. (b) Repeat using the method of linear exponential smoothing (Holt's method) with a = 0.4 and B=0.5 (c) Repeat using the method of linear exponential smoothing (Holt-Winter's method) with a = 0.445, B = 0.501 and y = 0.00 additive and multiplicative) (d) Find the accuracy of the forecast using (1) MAD (ii) MAPE (ii) MSE (iv) Bias (e) Suggest the appropriate method for the forecasting of the task (1) Evaluate and plot the tracking signal. State your observations 27 168 201