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)

c) Using multiple regression analysis, forecast revenues for each month of Year

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!