ADMN 2607 - Test Three on April 23 2022 - Word Table Tools A Rose Design Layout References Mailings Review View Help Table Design Layout Tell me what you want to do (Body) 11 A A A A DE AaBbCcDc AaBb CcDc AaB * Normal 1 No Spac... Headir I U. abe X x A. ary A 20 Font TE Paragraph Styles 08. (20 points) PART ONE OF TWO PARTS 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: 1 Year Computers Sold Printers Sold 1 1 1045 326 2 1610 510 3 3 860 296 4 1211 478 5 5 975 305 6 1117 506 7 1066 612 8 1310 560 9 1517 590 10 1246 676 I 8 a) In Excel, develop a linear trend line demand forecast for printers in year 11. Develop a linear regression model relating printer 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 accurate, 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 part (a). BE English (United States) Accessibility: Investigate O ET