Year Quarter | Sales 1 1 4 1 2 2 1 3 3 1 4 5 2 1 6 2 2 3 2 3 5 2 4 7 3 1 7 3 2 6 3 3 6 3 4 8 Q.1 Construct a time series plot for sales. Q.2 What type of pattern exists in the data? Q.3 Use a multiple linear regression model with dummy variables as follows: Qtrl =1if quarter 1, 0 otherwise Qtr2 =1if quarter 2, 0 otherwise Qtr3 = 1if quarter 3, 0 otherwise. Q.4 Compute the quarterly forecast for the next year based on the model you developed in Q.3 Q.5 Use a multiple linear regression model to develop an equation for trend and seasonal effects in the data as follows: Use dummyvariables you used in (. 3 to capture seasonal effects and create a variable "T" such that T =1 for quarter 1 inyear 1, T=2 for quarter 2ninyear 1, ... T=12 for quarter 4 in Year 3 Q.6 Compute the quarterly forecasts for the next year based on the model you developed in Q.5 Q.7 Which modelis more better? (a) the model you developed in Q.3 or (b) the modelyou developed in Q.57