Question: c) Using multiple regression analysis, forecast revenues for each month of Year 5 (20 marks) d) Compare the models, the best models from a and
c) Using multiple regression analysis, forecast revenues for each month of Year 5 (20 marks)
d) Compare the models, the best models from a and b, and the model based on regression analysis, and choose the best one. Which model is the best? Why? Show your calculations. (16 marks)

Plz answer!!
Model from A was moving average,
and from Model B is exponential smoothing
answer question C to get year 5 forecasted revenues using multiple regression analysis
please!!
1 Month 2 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 September 11 October 12 November 13 December 14 B D E Year 1 Year 2 Year 3 Year 4 59042 57495 56583 55658 62659 62622 66438 67164 22879 24273 27766 27795 29946 30492 31600 30667 26839 28237 29589 31962 19134 17893 20115 21096 20051 21126 19324 22778 19625 22876 23486 23144 19925 22641 24719 26601 58435 60796 60666 61385 87705 87815 86693 88581 77430 78711 80056 81048 1 Month 2 2 January 3 February 4 March 5 April 6 May 7 June 8 July 9 August 10 September 11 October 12 November 13 December 14 B D E Year 1 Year 2 Year 3 Year 4 59042 57495 56583 55658 62659 62622 66438 67164 22879 24273 27766 27795 29946 30492 31600 30667 26839 28237 29589 31962 19134 17893 20115 21096 20051 21126 19324 22778 19625 22876 23486 23144 19925 22641 24719 26601 58435 60796 60666 61385 87705 87815 86693 88581 77430 78711 80056 81048
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
