use excel

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. Continued... OPER 2P51 Sproule F 2022 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) 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. Continued... OPER 2P51 Sproule F 2022 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