Excel File Edit View Insert Format Tools Data AutoSave OFF 8. Quarter Insert Home to A V Draw Page Layout Tell me Conditional Formatting 2 Format as Table Alignment Number Cell Styles v Clipboard Font H19 B D G H Year 1 Sales 423 826 992 388 442 856 924 369 511 873 954 398 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 Year 2 10 Year 3 12 13 14 15 16 17 Sheet1 4. Compute the quarterly forec Quarter 1 forecast Quarter 2 forecast - Quarter 3 forecast = Quarter 4 forecast = Questions 12 points Save Consider the quarterly time series of smartphone sales in Ordy Salcs.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. Qul - 1 t quarter 10 otherwe; Qu2 - 1 il qurter 2,0 otherwise; 013-1 if quarter 3.0 otherwise 2. What is the value of y-intercept? 3. What is the coefficient for Our2 4. Compute the quarterly forecasts for next year based on the model developed in part b. Quarter forecast Quarter 2 forecast Quarter forecast Quarter 4 forecast Quarterly Sales (x Loe ety W P 12 0 A B C D E F G H 1 2 3 Year 1 2 3 5 6 7 Quarter 1 2 3 4 1 2 3 4 1 2 3 4 N 000 Sales 423 826 992 388 442 856 924 369 511 873 954 398 Year 2 Year 3 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35