Please solve it Asap

Q. (100 points) In 2020 and 2021. Al Murad company sold the following numbers of bycicles: Month: 1 5 6 10 11 12 2 3 220 185 Sales: 238 345 220 85 380 17 18 Month: 13 14 15 16 20 24 Sales: 135 145 185 219 240 420 550 410 560 4 245 a. (15 points) To EXCEL input the numbers 1 to 24 representing the months and the observed monthly sales as two columns. Plot and give information about the pattern of the data and explain which time series forecasting methods may give the best accuracy result, why? 7 8 295 19 b. (15 points) Compute the four-month moving-average forecast and place this in a third column. Be sure to align your forecast with the period for which you are forecasting. In another column, compute the forecast error for each month in which you have obtained a forecast. Plot your forecasts along with the sales values for the same months. Comment on the quality of the forecast. 9 280 21 120 110 23 450 580 510 22 c. (10 points) Using three other columns, compute the absolute error, the squared error, and the absolute percentage error. Using these results, find the MAD, MAPD, the mean squared error and bias E for the MA(4). Spring 2022 d. (15 points) Repeat parts (b) and (c) for eight-month moving averages. Plot your forecasts along with the sales values for the same months. Comment on the quality of the forecast. e. (10 points) Which method, MA(4) or MA(8), was more accurate for these data? Explain the reason behind your answer. f. (10 points) Using the MA(4) and MA(8), forecast the bycicle sales for months 25, 26, 27, and 28. i. MAD II. iii. Bias E iv. Mean Squared Error MAPD g. (10 points) Assume that the forecast for month 1 is 200. Repeat the previous calculations using simple exponential smoothing, and allow the smoothing constant a to be a variable. That is, the smoothing constant should be specified in an EXCEL cell. By experimenting with different values of a determine the value that appears to minimize the h. (15 points) Plot your forecasts along with the sales values for the same months for the exponential smoothing with the coefficient you selected in part (g). How does it work. Compare and discuss the forecasting accuracy of the method with the MA forecasts you developed. Q. (100 points) In 2020 and 2021. Al Murad company sold the following numbers of bycicles: Month: 1 5 6 10 11 12 2 3 220 185 Sales: 238 345 220 85 380 17 18 Month: 13 14 15 16 20 24 Sales: 135 145 185 219 240 420 550 410 560 4 245 a. (15 points) To EXCEL input the numbers 1 to 24 representing the months and the observed monthly sales as two columns. Plot and give information about the pattern of the data and explain which time series forecasting methods may give the best accuracy result, why? 7 8 295 19 b. (15 points) Compute the four-month moving-average forecast and place this in a third column. Be sure to align your forecast with the period for which you are forecasting. In another column, compute the forecast error for each month in which you have obtained a forecast. Plot your forecasts along with the sales values for the same months. Comment on the quality of the forecast. 9 280 21 120 110 23 450 580 510 22 c. (10 points) Using three other columns, compute the absolute error, the squared error, and the absolute percentage error. Using these results, find the MAD, MAPD, the mean squared error and bias E for the MA(4). Spring 2022 d. (15 points) Repeat parts (b) and (c) for eight-month moving averages. Plot your forecasts along with the sales values for the same months. Comment on the quality of the forecast. e. (10 points) Which method, MA(4) or MA(8), was more accurate for these data? Explain the reason behind your answer. f. (10 points) Using the MA(4) and MA(8), forecast the bycicle sales for months 25, 26, 27, and 28. i. MAD II. iii. Bias E iv. Mean Squared Error MAPD g. (10 points) Assume that the forecast for month 1 is 200. Repeat the previous calculations using simple exponential smoothing, and allow the smoothing constant a to be a variable. That is, the smoothing constant should be specified in an EXCEL cell. By experimenting with different values of a determine the value that appears to minimize the h. (15 points) Plot your forecasts along with the sales values for the same months for the exponential smoothing with the coefficient you selected in part (g). How does it work. Compare and discuss the forecasting accuracy of the method with the MA forecasts you developed