Integrated Excel (Algo) Problem 12.10The following data show the number of laptop computers sold each month at a retail store:\table[[Month,Unit Sales],[January,210],[February,240],[March,235],[April,250],[May,220],[June,190],[July,170],[August,320],[September,330],[October,280],[November,260],[December,322]]a. Assuming the estimated trend from May to June was -8 and the forecast for June was 200, use trend-adjusted exponential smoothing with a=0.3 and =0.1 to forecast sales for each of the seven following months: July, August, September, October, November, December, and January.Note: Round your intermediate calculations and final answers to 1 decimal place.b. Use regression for the data from January to June to create a forecast for each month from July to the following January.Note: Round your intermediate calculations and final answers to 1 decimal place.c. Compare the two sets of forecasts generated in parts (a) and (b). Which forecast model produces a better MFE? Which produces a better MAD?Navigation:Use the Open Excel in New Tab button to launch this question.When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect.A1GeneralAccessibility tab summary: Information for student is provided in rows 2 to 22. Statement 1 for student presentation is provided in12 The following data show the number of laptop computers sold each month at a retail store:3\table[[4,Month,Unit Sales],[5,January,210],[6,February,240],[7,March,235],[8,April,250],[9,May,220],[10,June,190],[11,July,170],[12,August,320],[13,September,330],[14,October,280],[15,November,260],[16,December,322],[,,]]17181920212223\table[[Trend,-8],[Alpha,0.3],[Beta,0.1],[Intercept,238.6667],[X Variable 1,-4.1429]]Required:Note: Use cells A4 to B22 from the given information to complete this question.a. Assuming the estimated trend from May to June was -4 and the forecast for June was 190, use trend-adjusted exponential smoothing with =0.3 and =0.2 to foreNote: Round your intermediate calculations and final answers to 1 decimal place.Graded WorksheetWorkbook StatisticsNote: Use cells A4 to B22 from the given information to complete this question.2627282930313233343536a. Assuming the estimated trend from May to June was -4 and the forecast for June was 190, use trend-adjusted exponential smoothing with Note: Round your intermediate calculations and final answers to 1 decimal place.\table[[,Month,,Unit Sales,F,T,FIT,Error,Absolute error],[1,January,1,210,,,,,],[2,February,2,240,,,,,],[33,March,3,235,,,,,],[34,April,4,250,,,,,],[35,May,5,220,,,,,],[36,June,6,190,,,,,],[37,July,7,170,,,,,],[38,August,8,320,,,,,],[39,September,9,330,,#,,,],[40,October,10,280,,,,,],[41,November,11,260,,,,,],[42,December,12,322,,,,,],[43,January,A1ABCDEFGH47 b. Use regression for the data from January to June to create a forecast for each month from July to the following January.48 Note: Round your intermediate calculations and final answers to 1 decimal place.49\table[[50,Month,,Unit Sales,F,Error,Absolute error],[51,July,7,170,,,],[52,August,8,320,,,],[53,September,9,330,,,],[54,October,10,280,,,],[55,November,11,260,,,],[56,December,12,322,,,],[57,January,13,,,,],[58,,,,,,],[59,,,,,MFE,MAD],[60,,,,,,],[61,c. Compare the two sets of forecasts generated in parts (a) and (b). Which forecast model produces a better MFE? Which produch a better MAD?]]626364656667686970717273Students: The scratchpad area is for you to do any additional work you need to solve this question or can be used to show your work.Nothing in this area will be graded, but it will be submitted with your assignment.Graded WorksheetWorkbook Statistics13,,,,,,],[44,45,,,,,,MFE,MAD],[46,,,,,,,,]]464748495051\table[[Month,,Unit Sales,F,Error,Absolute error],[July,7,170,,,]]Graded WorksheetWorkbook StatisticsPlease provide formulas that go in each cell.