A B Year 1 Quarter 1 2 3 4 1 2 Sales 423 826 992 388 442 856 924 369 511 873 954 398 Year 2 3 4 1 2 Year 3 3 4 Consider the quarterly time series of smartphone sales in Quarterly Sales.xlsx If there is a seasonal pattern in the time-series, use a multiple regression model with dummy variables as follows to develop an equation to account for seasonal effects in the data. Round the answers to two decimal places if needed. Qtrl = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. 2. What is the value of y-intercept? 3. What is the coefficient for Qtr2? 4. Compute the quarterly forecasts for next year based on the model developed in part b. Quarter 1 forecast = Quarter 2 forecast = Quarter 3 forecast = Quarter 4 forecast =