Microsoft Excel 2021365 - Beginner to Advanced - Adding Confidence Levels

The video tutorial explains how to use Excel to create forecasts using the ETS method, which includes seasonality. It covers adding confidence levels to forecasts, calculating upper and lower confidence bounds, and visualizing these in line charts. The tutorial also compares different forecasting methods and highlights the importance of confidence intervals in predicting future values.

What is the default confidence level percentage used in Excel for forecasts?

• 90%

• 99%

• 95%

• 85%

Which Excel formula is used to calculate the confidence interval for forecast values?

• forecast.ETS

• forecast.LINEAR

• forecast.ETS.confint

• forecast.CONF

What is the purpose of adding a confidence level column to the dataset?

• To calculate the average sales

• To determine the seasonality

• To find the maximum sales value

• To calculate confidence intervals for forecast values

How is the upper confidence bound calculated?

• By dividing the predicted value by the confidence level

• By multiplying the confidence level with the predicted value

• By adding the confidence level to the predicted value

• By subtracting the confidence level from the predicted value

What is the significance of the upper and lower confidence bounds in a forecast?

• They show the average predicted values

• They indicate the range where 95% of predicted values will fall

• They highlight the maximum and minimum sales

• They determine the seasonality of the data

What is the main advantage of using line charts in forecasting?

• They calculate the exact sales figures

• They provide a detailed numerical analysis

• They eliminate the need for confidence levels

• They help visualize predicted values and confidence bounds

What is the next step after understanding different types of forecasts?

• Removing the confidence bounds

• Calculating the median sales

• Using forecast sheets for easier forecasting

• Creating a pie chart