please solve all parts with excel

excel is important

OS. (20 points) Student Tech is a computer retailer that sells computers, printers and software in a convenient location near Algoma University Brampton. The sales manager of Student Tech had historical data on sales of computers and printers at this location for the past ten (10) years as follows Year Computers Sold Printers Sold 1 1045 335 2 1610 510 3 X60 29 4 1211 478 5 975 os 6 1117 7 1066 612 1310 560 1517 590 10 1246 S06 -) In Excel, develop a lincar trendline demand forecast for printers in year 11 b) Develop a linear regression model relating printet sales demand to computer sales demand to forecast printer sales demand in year 11, if 1300.computers are sold c) Compare your demand forecasts developed in (a) and (b) above and indicate which one appears to be accutate d) Develop an exponential smoothing model with alpha - 30 for the data above to forecast printer demand in year 11 and compare its accuracy to the lineal trend line forecast developed above in pant (a). Question 8 continues on page 7 Ox. (lSpoints) PART TWO OF TWO PARTS 6) Stadent Tech believes its printer sales are also related to the average price of its printers. It has the following historical data on hand for average printer prices over the past ten (10) years as follows Year S Average Printer Price 1 475 2 490 3 520 4 430 5 410 6 370 7 350 X 100 9 280 10 250 There are three parts to question 8 (c) PART TWO 1) Using Excel, develop the multiple regression cquution for these data 2) What is the coefficient of determination for this regression equation? 3) Determine the demand forecast for printer sales based on computer sales of 1500 units and an average printer price of $300