Practice More Quizzes:
Q:
What is the R-squared for your linear trend line above (to 3 decimal places)?
Q:
Use your trend line to forecast the sales for the September 2021 quarter (to 2 decimal places). What is this forecast? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Create a copy of the Sales sheet. We will use this new sheet to generate a Holt’s Exponential Smoothing model. What is the seed of the Level for this Holt’s Exponential Smoothing (HES) model (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using the difference of the first two observations, what is the seed of the Trend (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using an alpha of 0.2 and a beta of 0.5 to generate the HES forecasts, what is the value of the level in December 2012 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using an alpha of 0.2 and a beta of 0.5 to generate the HES forecasts, what is the value of the trend in December 2012 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using an alpha of 0.2 and a beta of 0.5 to generate the HES forecasts, what is the forecast for September 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using an alpha of 0.2 and a beta of 0.5 to generate the HES forecasts, what is the forecast for December 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Use Solver to minimise the Mean Squared Error by changing the value of alpha and the value of beta. What is the optimal value of alpha (to 2 decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Use Solver to minimise the Mean Squared Error by changing the value of alpha and the value of beta. What is the optimal value of beta (to 2 decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
For the optimised values of alpha and beta, what is the forecast for September 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
For the optimised values of alpha and beta, what is the forecast for December 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Now go to the Tourists sheet of the same file where we will perform a Winters Exponential Smoothing forecast. The forecasting sheet has already been set up, with some missing values. As you populate the missing values via this question and the rest of the questions, the sheet will become complete. Using the average of the first 12 observations, what would be the seed for the level (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using the method discussed in the video, what is the seed for the trend (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using the method discussed in the video, what is the seed for the month of October (rounded to 2 decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using the WES method with an alpha of 0.1, a beta of 0.2 and a gamma of 0.5, what is the forecast for December 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using the WES method with an alpha of 0.1, a beta of 0.2 and a gamma of 0.5, what is the forecast for November 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Use Solver to minimise the MSE by changing the values of alpha, beta, and gamma. What is the optimised value for gamma (rounded to 2 decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Q:
Using the WES method with the optimised values for alpha, beta, and gamma, what is the forecast for November 2021 (rounded to zero decimal places)? Make sure you have the un-rounded figure in your spreadsheet!
Subscribe
0 Comments
Find Questions in This Page: "CTRL+F"
