Question 3 - Wind and Solar Power The sheet named Wind and Solar contains data on the capacity of wind and solar power generation in Ontario from 2019 to 2021. The chart provided indicates the presence of both a trend and a seasonal component to this data. Create a forecast for monthly wind capacity using both a trend value and a seasonal index. Create a line chart showing both the actual and forecast values for each month of 2019, 2020, 2021 and the forecast for 2022. Ensure your chart has appropriate axis labels and title. (3 marks) Create a forecast for monthly solar capacity using both a trend value and a seasonal index. Create a line chart showing both the actual and forecast values for each month of 2019, 2020, 2021 and the forecast for 2022. Ensure your chart has appropriate axis labels and title. (3 marks) Generator Output by Fuel Type 1400 1200 1000 800 600 400 Generator Output by Fuel Type M W ww -wind -solar Time >eriod Year 1 2019 Month wind solar Jan 1435.37 24.86 2 Feb 1205.47 30.39 1800 3 Mar 1269.84 59.24 1600 4 Apr 1065.94 64.42 5 May 633.64 72.41 6 Jun 379.75 78.29 7 Jul 511.46 91.25 Kilowats 8 Aug 507.27 90.26 9 Sep 695 71.19 10 Oct 818.39 47.55 200 11 Nov 1148.5 27.05 0 12 Dec 1306.29 19.45 13 2020 Jan 1184.09 19.39 14 Feb 1363.44 42.02 15 Mar 1210.63 61.93 16 Apr 960.62 75.59 17 May 876.93 89.1 18 Jun 602.6 98.68 19 Jul 514.14 94.47 20 Aug 584.31 88.27 21 Sep 889.53 71.89 22 Oct 897.57 50.63 23 Nov 1281.06 37.62 24 Dec 1392.26 19.79 25 2021 Jan 917.66 25.09 26 Feb 1192.33 46.83 27 Mar 1526.97 71.18 28 912.06 76.71 29 May 735.62 92.56 30 Jun 849.66 91.25 31 Jul 600.19 84.71 32 Aug 521.32 85.98 33 Sep 912.22 72.79 34 Oct 981.87 48.99 35 Nov 1322.68 37.66 36 Dec 1524.54 18.23 37 2022 Jan 38 Feb 39 Mar 40 Apr 41 May 42 Jun 43 Jul 44 Aug 45 Sep 46 Oct 2019 2020 2021