70.2K

Verified Solution

Link Copied!

Please provide the formulas used as per to excel functions

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) 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

Answer & Explanation Solved by verified expert

See Answer