164 165 Problem 4 166 Actual Demand Seasonal 167 Period x Deseasonalized Year Quarter Factor 168 Demand y_d 1 2015 1 398 169 2 II 580 170 3 III 383 171 4 IV 81 172 5 2016 1 538 173 6 II 673 174 7 III 459 175 8 IV 141 176 2017 1 599 177 10 II 828 178 11 III 544 179 12 IV 128 180 13 2018 676 181 14 11 966 182 15 611 183 16 IV 166 184 17 2019 1 804 185 18 1094 186 19 722 187 20 IV 149 21 2020 899 189 22 1211 190 23 784 191 24 IV 175 192 25 2021 193 26 134 27 195 28 IV 196 197 198 a. Use time-series decomposition and the regression program included in the Excel Data Analysis ToolPak to fin 199 188 = = - ==-== 2 Problem fen Year 2015 maurpet Actual Demandy Seasonal Factor Deseasonal Demandyd 390 Period 1 2 3 4 5 580 11 173 IV 1 2016 538 673 8 IV 2017 == == 141 599 10 11 170 180 13 2018 2010 IV 1 544 128 676 966 611 166 804 1094 722 140 09 1211 f| IV 1 31 2020 784 11: -- ZEE 175 2021 W 106 70 meses decomposition and the regression program included in the Excel Data Analyse ToolPak to find the seasonaly-adjusted forecasts for Quarters and in 2021 2 3 Directions: 1. Complete the following four problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time given by Canvas 5 2. Do not change the name of this file when you save your work. The file should be called "Graded Homework 1.xls 6 3. Express all real numbers in this spreadsheet in FOUR (4) decimal places 7 4. To facilitate grading, please do not delete or insert ROWS 164 165 Problem 4 166 Actual Demand Seasonal 167 Period x Deseasonalized Year Quarter Factor 168 Demand y_d 1 2015 1 398 169 2 II 580 170 3 III 383 171 4 IV 81 172 5 2016 1 538 173 6 II 673 174 7 III 459 175 8 IV 141 176 2017 1 599 177 10 II 828 178 11 III 544 179 12 IV 128 180 13 2018 676 181 14 11 966 182 15 611 183 16 IV 166 184 17 2019 1 804 185 18 1094 186 19 722 187 20 IV 149 21 2020 899 189 22 1211 190 23 784 191 24 IV 175 192 25 2021 193 26 134 27 195 28 IV 196 197 198 a. Use time-series decomposition and the regression program included in the Excel Data Analysis ToolPak to fin 199 188 = = - ==-== 2 Problem fen Year 2015 maurpet Actual Demandy Seasonal Factor Deseasonal Demandyd 390 Period 1 2 3 4 5 580 11 173 IV 1 2016 538 673 8 IV 2017 == == 141 599 10 11 170 180 13 2018 2010 IV 1 544 128 676 966 611 166 804 1094 722 140 09 1211 f| IV 1 31 2020 784 11: -- ZEE 175 2021 W 106 70 meses decomposition and the regression program included in the Excel Data Analyse ToolPak to find the seasonaly-adjusted forecasts for Quarters and in 2021 2 3 Directions: 1. Complete the following four problems, save your work, then submit your saved spreadsheet to Canvas by the due date and time given by Canvas 5 2. Do not change the name of this file when you save your work. The file should be called "Graded Homework 1.xls 6 3. Express all real numbers in this spreadsheet in FOUR (4) decimal places 7 4. To facilitate grading, please do not delete or insert ROWS
