Show transcribed image text Question3 (23 arks) sing tinear regrossion to Forecast Product Demand The supply chain manager secks a betiet way to forecast the demand fer door hinges lieves that the domand is reliied to ad and advertising data for the past 5 months: an Sales (Thousands of Units) Advertising (Thousands of Month 264 118 165 101 209 2.5 1.3 14 1.0 2.0 The company will spend S1,750 next month on alvertising for the prodact Use linear regression to develop an equation and a forecast for this prodact solution We used POAM for W'indows to determsine the best values of a, b, the correlation coefficient, the coefficiet of determination, and the standurd eror of the estimase The regression equation is –8 135; b-109229X r 0.980; 12 0.960 syx 15.603: Y- 8135+ 109 229x and the regression line is shown in below Explain the case example and its solution to demonstrate your understandieg of this linear regression causal analysis (25 marks)