PLEASE HELP WITH D) AND E)

Data report (refer to the Excel file) the number of new constructions for residential homes,per month, in thousands, from 2013 to 2018 in the state of Oregon. a) Prepare e greph of the date. (4 point) by compute forecasts for the twelve months of 2019 using finear regression. (7 point) # Prepare a graph of the forecast date. (4 point) d) Compute the MAD of your model. (5 point) e) Compute and chart the tracking signal. (5 point) Hint: You can use the Excel template of the similar example in the slides. Month absolute to 1 4 error 5.31 2.63 6.05 8.73 * Jan-13 Feb-13 Mar-13 Apr-13 May-13 Jun-13 Jul-13 Aug-13 Sep-13 Oct-13 Nov-13 Dec-13 Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Oct-14 Nov-14 Dec-14 Jan-15 Feb-15 Mar-15 Apr-15 May-15 Jun-15 Jul 15 Aug-15 Sep-15 Oct-15 Nov-15 Dec-15 Jan-16 Feb-16 Mar-16 Apr-16 May-16 numbers (t)constructions () ty 1 29 29 2 32 64 3 41 123 4 44 176 5 49 245 6 47 282 7 46 322 8 47 376 9 43 387 10 45 450 11 34 374 12 31 372 13 35 455 14 43 602 15 46 690 16 46 736 17 43 731 18 41 738 19 44 836 20 47 940 21 41 861 22 40 880 23 32 736 24 32 768 25 34 850 26 40 1040 27 43 1161 28 42 1176 29 43 1247 30 44 1320 31 39 1209 32 40 1280 33 33 1089 34 32 1088 35 31 1085 36 28 1008 37 34 1258 38 29 1102 39 36 1404 40 42 1680 41 43 1763 16 25 36 49 64 81 100 121 144 169 196 225 256 289 324 361 400 441 484 529 576 625 676 729 784 841 900 961 1024 1089 1156 1225 1296 1369 1444 1521 1600 1681 forecast 34.31 34.63 34.95 35.27 35.59 35.91 36.23 36.55 36.87 37.19 37.51 37.83 38.15 38.47 38.79 39.11 39.43 39.75 40.07 40.39 40.71 41.03 41.35 41.67 41.99 42.31 42.63 42.95 43.27 43.59 43.91 44.23 44.55 44.87 45.19 45.51 45.83 46.15 46.47 46.79 47.11 error -5.31 -2.63 6.05 8.73 13.41 11.09 9.77 10.45 6.13 7.81 -3.51 -6.83 -3.15 4.53 7.21 6.89 3.57 1.25 3.93 6.61 0.29 -1.03 -9.35 -9.67 -7.99 -2.31 0.37 -0.95 -0.27 0.41 -4.91 -4.23 -11.55 -12.87 -14.19 -17.51 - 11.83 -17.15 -10.47 -4.79 -4.11 AP8*A@8*SK 13.41 11.09 9.77 10.45 6.13 7.81 3.51 6.83 3.15 4.53 7.21 6 89 3.57 1.25 3.93 6.61 0.29 1.03 9.35 9.67 7.99 2.31 0.37 0.95 0.27 0.41 4.91 4.23 11,55 12.87 14.19 17.51 11.83 17.15 10.47 4.79 4.11 Jun-16 42 44 1848 1764 47.43 -3.43 3.43 2999 44 48 45 44 40 37 45 49 62 Jul-16 Aug-16 Sep-16 Oct-16 Nov-16 Dec-16 Jan-17 Feb-17 Mar-17 Apr-17 May-17 Jun-17 Jul-17 Aug-17 Sep-17 Oct-17 Nov-17 Dec-17 Jan-18 Feb-18 Mar-18 Apr-18 May-18 Jun-18 Jul-18 Aug-18 Sep-18 Oct-18 Nov-18 Dec-18 total 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 828 & 9 8 8 8 8 988*9* 889 62 58 59 64 62 50 52 50 44 51 56 60 65 64 63 63 72 61 65 51 47 3288 1892 2112 2025 2024 1880 1776 2205 2450 3162 3224 3074 3186 3520 3472 2850 3016 2950 2640 3111 3472 3780 4160 4160 4158 4221 4896 4209 4550 3621 3384 129961 1849 1936 2025 2116 2209 2304 2401 2500 2601 2704 2809 2916 3025 3136 3249 3364 3481 3600 3721 3844 3969 4096 4225 4356 4489 4624 4761 4900 5041 5184 127020 47.75 48.07 48.39 48.71 49.03 49.35 49.67 49.99 50.31 50.63 50.95 51.27 51.59 51.91 52.23 52.55 52.87 53.19 53.51 53.83 54.15 54.47 54.79 55.11 55.43 55.75 56.07 56.39 56.71 57.03 -3.75 -0.07 -3.39 -4.71 -9.03 - 12.35 -4.67 -0.99 11.69 11.37 7.05 7.73 12.41 10.09 -2.23 -0.55 -2.87 -9.19 -2.51 2.17 5.85 10.53 9.21 7.89 7.57 16.25 4.93 8.61 -5.71 - 10.03 -0.24 3.75 0.07 3.39 4.71 9.03 12 35 4.67 0.99 11.69 11.37 7.05 7.73 12.41 10.09 2.23 0.55 2.87 9.19 2.51 2.17 5.85 10.53 9.21 7.89 7.57 16.25 4.93 8.61 5.71 10.03 483.94 66 67 68 69 70 71 72 2628