Please answer question 5-36 using excel

hich :ast? dous Head Lgeif mths Est 535 1 2 3 4 (1. A major source of revenue in Texas is a state sales tax on certain types of goods and services. Data are com- piled. and the state comptroller uses them to project future revenues for the state budget. One particular category of goods is classied as Retail Trade. Four years of quarterly data {in 15 l .tJUU.UUs} for one par- ticular area of southeast Texas follow: QUARTER YEAR! YEAR! YEAR] 'YEAR4 2I8 225 234 250 24? 254 265 283 243 255 264 239 292 299 32? 356 [a] Compute a seasonal index for each quarter based on a CMA. {b} Deseasonaliae the data. and develop a trend line on the deseasonaliaed data. [c] Use the trend line to forecast the sales for each quarter of year 5. (d) Use the seasonal indices to adjust the forecasts found in part (c) to obtain the final forecasts. Using the data in Problem 5-35. develop a multiple regression model to predict sales [with both trend and seasonal components]. using dummy variables to incorporate the seasonal factor into the model. Use this model to predict sales for each quarter of the nest year. Comment on the accuracy of this model