Problem description: The quarterly sales for specific educational software over the past five years are given in the following table. YEARYEAR2 YEAR3 YEAR4 YEARS Quarter 11710 1820 1830 1920 2010 Quarter 2 960 Quarter 32720 910 2840 1090 2900 1130 3200 1230 3350 Quarter 4 2430 2200 27402790 You are asked to conduct a time series analysis on this set of data and provide your quarterly forecasts of sales for specific educational software for Year 6. You should use the forecasting tools you leamed in your BSAT 382 class to conduct an appropriate analysis in order to provide the manager with your findings. Your forecasts have to be done on computer, not by hand. Your final answers (typed; NOT hand-written) should be no more than one page long and should include answers to the following questions: (1) How do you know there is a seasonal variation in the data? (2) What are the values of quarterly seasonal indexes? (3) How can you tell if there is an upward, downward or no trend? (4) How do you interpret the values of”a” and “b” (in the context of this problem) in the following trend projection equation? T 5) What are your forecasted quarterly sales for Year 6? a + b * t In addition to your one-page writing, please attach the appropriate computer printouts, and turn it in on November 27, 2018 at the beginning of the class.