Microsoft Excel 2021365 - Beginner to Advanced - Exercise 10 - create a forecast to predict temperatures

This video tutorial covers the process of forecasting using temperature data from 2015 to 2021. It introduces various forecasting techniques, allowing learners to choose between using formulas or a simpler method with forecast sheets. The tutorial provides a step-by-step guide on creating a forecast for 2022 and 2023 using forecast sheets, emphasizing the importance of understanding the process and checking for seasonality and confidence intervals. The video concludes with a review of the forecast and adding a chart title for clarity.

What years does the temperature data cover?

What is the task given to the students regarding temperature forecasting?

What methods can students use to create the forecast?

What is the confidence interval set to in the forecast options?

What title is suggested for the chart created in the forecasting exercise?