Expand To Get Answers
Final Assessment — All Course Content » Week 5 » Excel Time Series Models For Business Forecasting » Re⥃askly
Final assessment — all course content
Graded Quiz • 30 min Quiz19 Questions Week 5
Re⥃askly Logo

Final assessment — all course content

Graded Quiz • 30 min Quiz19 Questions Week 5
Practice More Quizzes:
Quiz
18 Questions Week 2
Quiz
19 Questions Week 4
Quiz

Q:

Which of the following forecasting methods is appropriate for time series data that is level?

Q:

Which of the following forecasting methods is appropriate for time series data that exhibits a trend?

Q:

Which of the following forecasting methods is appropriate for time series data that exhibits seasonality?

Q:

Look at the DeSeas Turnover sheet. Using the 4-period Moving Average method, calculate a forecast for January 2022. What is your result rounded to 2 decimal places?

Q:

Look at the DeSeas Turnover sheet. Using the Naïve Forecast method, calculate a forecast for January 2022. What is your result rounded to 2 decimal places?

Q:

Consider the DeSeas Turnover sheet. Why would any of the forecasting methods used so far (in Questions 4 – 6), as well as Simple Exponential Smoothing not be appropriate?

Q:

Use the DeSeas Turnover sheet to perform a Holt’s Exponential Smoothing. Using an alpha of 0.2 and beta of 0.5, what is the Level for December 2021 (rounded to 2 decimal places)?

Q:

Consider your Holt’s Exponential Smoothing for the DeSeas Turnover sheet. Using an alpha of 0.2 and beta of 0.5, what is the Trend for December 2021 (rounded to 2 decimal places)?

Q:

Consider your Holt’s Exponential Smoothing for the DeSeas Turnover sheet. Using an alpha of 0.2 and beta of 0.5, what is the Forecast for January 2022 (rounded to 2 decimal places)?

Q:

Use the Raw Turnover sheet to perform a Winters Exponential Smoothing. Using an alpha of 0.1, beta of 0.2, and gamma of 0.5, what is the Level for January 2013 (rounded to 2 decimal places)?

Q:

For the Raw Turnover sheet, using an alpha of 0.1, beta of 0.2, and gamma of 0.5, what is the Trend for January 2013 (rounded to 2 decimal places)?

Q:

Consider your Winters Exponential Smoothing for the Raw Turnover sheet. Using an alpha of 0.1, beta of 0.2, and gamma of 0.5, what is the Seasonal component for January 2013 (rounded to 2 decimal places)?

Q:

Consider your Winters Exponential Smoothing for the Raw Turnover sheet. Using an alpha of 0.1, beta of 0.2, and gamma of 0.5, what is the Forecast for January 2022 (rounded to 2 decimal places)?

Q:

Consider your Winters Exponential Smoothing for the Raw Turnover sheet. Use Solver to optimise the parameters, what is the optimised value of alpha (rounded to 3 decimal places)?

Q:

Now look at the Sales sheet where a Decomposition method is being used for forecasting. What is the value of the Seasonal Relative for January 2021 (rounded to 3 decimal places)?

Q:

Considering the Sales sheet. What is the value of the Deseasonalised data for January 2021 (rounded to 2 decimal places)?

Q:

Considering the Sales sheet. Draw a linear trend line for the De-seasonalised data. What is the equation of this trend line?

Q:

Considering the Sales sheet. What is the forecast for January 2021 (rounded to zero decimal places)?

Q:

Considering the Sales sheet. What is the forecast for November 2021 (rounded to zero decimal places)?

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
Find Questions in This Page: "CTRL+F"