J \\_ Eco SHESpEIAssignment 3 due by midnight on April 4, 2022(Chapter 5111i-l Total points 125. Submit through DEL in WordJExcel formaL single ormultiple les. Must show all Excel work, answer all parts of the question= and write necessary explanations to earn full points. You have to use Excel to solve this numerical problem (pm-jectj-l The following table gives monthly data for four years in million tons of consumption of ice cream in a country- Plot the series and comment on the visible seasonality and trend. Estimate the centered moving averages for this monthly series. Plot CM and comment. Next: estimate the SJ component which only includes seasonal and irregular movements of the series. Then nd the seasonal indexes for the twelve months removing the irregular component. Find the de seasonalized levels for the series. Plot Deseasonalized Y and comment. Then estimate the trend values for the four sample years and the 12 months of the year 24319 {beyond the sample years) using linear regression. Finally, make the foreclast for the 12 months of EDIE using the Ratioto Moving Average method to capture the Trend and Seasonal patterns= using Excel. Plot the forecasted values for the 6G periods including 12 months of the year 2019. Plot the errors for in sample periods and calculate EMISE. Comment on the error plot with respect to the existence of pattern or lack of visible patterns!-l m ____+' -___+' -___+' -___+' m _-_--+' -___+' _-_--+' \"ms _-_--+' -___+' ____+' 4.: {lIint: First: you have to type the data in column form in Excel)+l