Problem 1: Sheet 1 a) Find on the Internet a time series, which contains at least 20 entries. Provide a short description of this time series. Also provide a link to that data set. b) Perform 2 different suitable forecast methods for the next time period. c) Compare 2 forecast methods using mean square error (MSE).

Problem 1: Sheet 1 a) Find on the Internet a time series, which contains at least 20 entries. Provide a short description of this time series. Also provide a link to that data set. b) Perform 2 different suitable forecast methods for the next time period. c) Compare 2 forecast methods using mean square error (MSE).

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section: Chapter Questions

Problem 42P: The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars)...

See similar textbooks

Similar questions

The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.
The following data show the number of liters of gasoline sold by Mackrin's in Colorado for the past 12 weeks. Which forecasting model would you recommend to Mackrin's manager? Why? What demand forecast would you recommend for week 13? Week Actual Demand (1000 liters) Forecasting (1000 liters) FSMA /A-F/ FWMA /A-F/ FES, α=0.3 /A-F/ 1 17 2 21 17 4 3 19 18.2 0.8 4 23 19 4 18.44 4.56 5 18 21 3 20.8 2.8 19.81 1.81 6 16 20 4 20 4 19.3 3.3 7 20 19 1 18.3 2.3 18.31 1.69 8 18 18 0 18.7 0.7 18.82 0.82 9 22 18 4 18.2 4.2 18.6 3.4 10 20 20 0 19.8 0.2 19.62 0.38 11 15 20 5 20.2 5.2 19.73 4.73 12 22 19 3 18.2 3.8 18.3 3.7 13 19 19.5 19.41 MAD 2.67 2.9 2.7 MSE 10.22…
Explain the trade-off between responsiveness and stability in a forecasting system that uses time-series data. Who needs to be involved in preparing forecasts? 3. How has technology had an impact on forecasting? What capability would an organization have to have to not need forecasts? Give three examples of unethical conduct involving forecasting and the ethical principle each violates
Please help with the correct answers in details: Centerville Bikes and Stuff (CBS) sells motorcycles and accessories. The number of helmets sold by CBS per week for the past six weeks follows. Week 1 2 3 4 5 6 Value 19 14 17 12 18 15 a) Develop the three-week moving average for this time series. (Round your answers to two decimal places.) Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 What is Compute MSE? (Round your answer to two decimal places.) MSE = ? What is the forecast for week 7? b) Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 What is Compute MSE. (Round your answer to two decimal places.) MSE = ? What is the forecast for week 7? (Round your answer to two decimal places.) c) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1…
K 2. Setting an advertising budget is a forecasting exercise. What are the fundamental principles that should be adhered to when undertaking forecasting? Be conservative and use the best evidence-based technique available Be innovative and use multiple methods and choose the optimal one Be conservative and use multiple evidence-based techniques, taking the average result Be innovative and use multiple evidence-based techniques, taking the average result
Paraphrase this one. Analyze and elaborate in 200 words. Why organizations use time series data analysis? Time series analysis helps organizations understand the underlying causes of trends or systemic patterns over time. Using data visualizations, business users can see seasonal trends and dig deeper into why these trends occur. With modern analytics platforms, these visualizations can go far beyond line graphs. When organizations analyze data over consistent intervals, they can also use time series forecasting to predict the likelihood of future events. Time series forecasting is part of predictive analytics. It can show likely changes in the data, like seasonality or cyclic behavior, which provides a better understanding of data variables and helps forecast better.
If Mr. Ishaq is the Director of KIA Company in Nizwa, what does he need to do to predict customer sales or product demand? a. Production b. Marketing c. Forecasting d. Coordination Clear my choice
All forecasts are subject to error. Do you think topmanagers would be concerned about the effectson the firm if sales revenues or unit costs, forexample, turned out to be different from the forecasted level? How could you provide informationon the effects of such errors?
2.1 Compare and contrast between the grassroots forecasting technique and the Delphi method. 2.2 Explain integrated service providers in logistics management
What factors make forecasting at Deckers particularly challenging? Howcan forecasts be made for seasonal, fashionable products for whichthere is no history file? What are the costs of over-forecasting demandfor such items? Under-forecasting?
MSE answer for part a = 5.95 is incorrect. Please do recalculations with the correct answer. also the rest of the question was not answered so here it is: Use ? = 0.2 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two decimal places.) Use ? = 0.4 to compute the exponential smoothing values for the time series. Week Time SeriesValue Forecast 1 19 2 14 3 17 4 12 5 18 6 15
Forecasting is critical in modern times. Business organizations manifested more concern with anticipating the future, and as a consequence, a number of highly successful consulting firms emerged to provide forecasting help for governments and businesses. You are required: iii. Identify the different levels that forecasting of business trends takes place. iv. Give 3 examples where long-range forecasting can be used v. Do you think forecasting is always correct and accurate? Discuss this assertion in detail