Question 5 0.25 pts Open the monthly call volume JMP file and see that it contains four years of monthly call volume data. Answer the following questions in preparation for applying the (1) moving average method of order 5 to examine a level data pattern, and (2) linear regression for seasonality to examine 12 levels of monthly fluctuations. 1. Before you can apply the moving average method, you must create a column that contains a running count of [Select] time periods from Year 1 Month 1 to Year 4 Month 12 to serve as the [X, Time ID ). 2. The column of running count described above is created by right-clicking the "Year" column then selecting [Select] 3. Before you can apply the linear regression for seasonality method, you must create [Select] columns of dummy variables to represent the values in "Month". 4. The columns of dummy variables described above is created by selecting the [ Select] column then selecting Cols > [ Select] monthly call volume.jmp monthly ca... Call Year Month Volu... 1 1 1925 1 2 1 2 2978 3 1 3 4 1 4 5 1 5 3676 1821 1710 1589 1613 1 6 6 7 1 7 1 8 1 9 8 9 10 11 2208 2606 3795 3678 1 10 11 1 12 1 12 3383 2718 Columns (370) 13 2 1 Year 14 2 2 3608 3601 15 2 3 Month 1 Call Volume 16 4 3997 17 2 5 2 6 18 19 2 7 3235 2724 4214 3814 4283 20 2 8 21 2 9 22 2. 10 3781 2 11 23 24 4672 5738 2 12 25 3 1 5654 26 3 2 27 3 3 3 4 28 29 3620 5810 5578 4506 4239 3 5 30 3 6 31 3 7 3092 4687 32 3 8 3 9 33 34 3 10 35 3 11 48 36 3 12 Rows 1 rows elected xcluded idden abelled 6161 3763 4672 6138 7123 5553 6928 37 4 1 0 0 0 1 38 4 2 39 4 3 40 4 4 4910 5353 41 4 5 42 4 6 5895 4 5628 43 44 7 8 4 7073 45 4 9 5503 46 4 10 48 1 0 0 0 7667 7451 47 4 11 48 4 12 7595 Question 5 0.25 pts Open the monthly call volume JMP file and see that it contains four years of monthly call volume data. Answer the following questions in preparation for applying the (1) moving average method of order 5 to examine a level data pattern, and (2) linear regression for seasonality to examine 12 levels of monthly fluctuations. 1. Before you can apply the moving average method, you must create a column that contains a running count of [Select] time periods from Year 1 Month 1 to Year 4 Month 12 to serve as the [X, Time ID ). 2. The column of running count described above is created by right-clicking the "Year" column then selecting [Select] 3. Before you can apply the linear regression for seasonality method, you must create [Select] columns of dummy variables to represent the values in "Month". 4. The columns of dummy variables described above is created by selecting the [ Select] column then selecting Cols > [ Select] monthly call volume.jmp monthly ca... Call Year Month Volu... 1 1 1925 1 2 1 2 2978 3 1 3 4 1 4 5 1 5 3676 1821 1710 1589 1613 1 6 6 7 1 7 1 8 1 9 8 9 10 11 2208 2606 3795 3678 1 10 11 1 12 1 12 3383 2718 Columns (370) 13 2 1 Year 14 2 2 3608 3601 15 2 3 Month 1 Call Volume 16 4 3997 17 2 5 2 6 18 19 2 7 3235 2724 4214 3814 4283 20 2 8 21 2 9 22 2. 10 3781 2 11 23 24 4672 5738 2 12 25 3 1 5654 26 3 2 27 3 3 3 4 28 29 3620 5810 5578 4506 4239 3 5 30 3 6 31 3 7 3092 4687 32 3 8 3 9 33 34 3 10 35 3 11 48 36 3 12 Rows 1 rows elected xcluded idden abelled 6161 3763 4672 6138 7123 5553 6928 37 4 1 0 0 0 1 38 4 2 39 4 3 40 4 4 4910 5353 41 4 5 42 4 6 5895 4 5628 43 44 7 8 4 7073 45 4 9 5503 46 4 10 48 1 0 0 0 7667 7451 47 4 11 48 4 12 7595
