Help with the last question! A statistical program is recommended.Consider the following time series.QuarterYear 1Year 2Year 31716862249415135860534778071(a) Construct a time series plot.90809090-907080808060707070-6050505040 -40-2010202020-1010101 241412 341341.4134414134341414Year 1Year 2Year 3Year 1Year 2Year 3Year 1Year 2Year 3Year 1Year 2Year 3Year/QuarterYear/QuarterYear/QuarterYear/QuarterWhat type of pattern exists in the data?o The time series plot shows a horizontal pattern, but there is also a seasonal pattern in the data.The time series plot shows a trend pattern, but there is also a seasonal pattern in the data.The time series plot shows a horizontal pattern with no seasonal pattern present.The time series plot shows a trend pattern with no seasonal pattern present.(b) Use the following dummy variables to develop an estimated regression equation to account for seasonal effects in the data:X1 = 1 if quarter 1, 0 otherwise; x2 = 1 if quarter 2, 0 otherwise; x3 = 1 if quarter 3, 0 otherwise.(c) Compute the quarterly forecasts for next year.quarter 1 forecastEnter an exact number.quarter 2 forecastquarter 3 forecastquarter 4 forecast

b) Let x1=1 if the quarter 1 =0 otherwisex2=1 if the quarter 2 =0 otherwisex3=1 if the quarter 3 =0 otherwise y x1 x2 x3 71 1 0 0 68 1 0 0 62 1 0 0 49 0 1 0 41 0 1 0 51 0 1 0 58 0 0 1 60 0 0 1 53 0 0 1 77 0 0 0 80 0 0 0 71 0 0 0 Excel Procedure: Enter the data for y, x1, x2, x3 in Excel Go to Data Click on Data Analysis.> ‘Regression’. Select y under ‘Input Y Range’. Select x1, x2, x3 under ‘Input X Range’. Click on ‘OK’. Output: From the output, the regression equation is, Y=76-9x1-29x2-19x3 c. For quarter 1, Let x1=1, x2=0, x3=0 in regression equation. Y=76-(9*1)-(29*0)-(19*0)=67 For quarter 2, Let x1=0, x2=1, x3=0 in regression equation. Y=76-(9*0)-(29*1)-(19*0)=47 For quarter 3, Let x1=0, x2=0, x3=1 in regression equation. Y=76-(9*0)-(29*0)-(19*1)=57 For quarter 4, Let x1=0, x2=0, x3=0 in regression equation. Y=76-(9*0)-(29*0)-(19*0)=76