Please provide answers for question 4.1 and 4.2 a and 4.2b
Table 2.1: Actual sales data for the reading glasses during 2021 QUESTION 4 Using the sales data of the reading glasses in Table 2.1 (question 3), answer the following questions: 4.1 Calculat the three-morthweighted movingaverage montly brecasts br the pecod April 2021 - December 2021. Use weights of 0.5, and 0.2 for te most recent and oldest morthy data respectively and 0.3 for the middle month (show all wonings). (9 mark) 4.2 Desemine the Mean Absolut Deviatoc (MAD) of the tree-montweighted-movingaverage morttly forecasts br the April - Decenber 2021 period. (4 marks) a. The linear regressionequation of the sales of reading gasses for the 20e1 financial year is given by the expression: y=201.4x+4091 (ahere y denotes morthly sales, and ' x, the nurrber representing the monh For example, x=1,2,3, etc, Ithe month is Jaruay. Febrary, March, etc.) Use the regression equation bo detarmine the Mean Absolute Deviafon (MAD) of the regression brecass fot the Aprl- December 2021 period. (5 marks) b. Which of te swo metods is beter at brecasting the sales of the reading ciasses? Explan. (2. marks) Table 2.1: Actual sales data for the reading glasses during 2021 QUESTION 4 Using the sales data of the reading glasses in Table 2.1 (question 3), answer the following questions: 4.1 Calculat the three-morthweighted movingaverage montly brecasts br the pecod April 2021 - December 2021. Use weights of 0.5, and 0.2 for te most recent and oldest morthy data respectively and 0.3 for the middle month (show all wonings). (9 mark) 4.2 Desemine the Mean Absolut Deviatoc (MAD) of the tree-montweighted-movingaverage morttly forecasts br the April - Decenber 2021 period. (4 marks) a. The linear regressionequation of the sales of reading gasses for the 20e1 financial year is given by the expression: y=201.4x+4091 (ahere y denotes morthly sales, and ' x, the nurrber representing the monh For example, x=1,2,3, etc, Ithe month is Jaruay. Febrary, March, etc.) Use the regression equation bo detarmine the Mean Absolute Deviafon (MAD) of the regression brecass fot the Aprl- December 2021 period. (5 marks) b. Which of te swo metods is beter at brecasting the sales of the reading ciasses? Explan. (2. marks)