Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Please provide answers for question 4.1 and 4.2 a and 4.2b image text in transcribed
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)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions