Question

1. Smoothing methods (conceptual) Aa Aa Monthly time series data on coin collections from about 70,000 New York City parkingThe monthly time series data on New York City parking meter collections are shown again on the following graph. Two forecasts

The monthly time series data on New York City parking meter collections are shown again on the following graph. Two forecasts

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Moving averages are used to smooth out the trend of the time series data.

The bigger the window we take for the moving averages, the smoother our time series becomes.

(a) The blue ( square symbol) line is the " Three month moving average"

(b) The pink ( diamond symbol ) line is the " weighted moving average forecast"

(c) We see in the below graph that the lower the value of alpha, the smoother the curve and the higher the alpha the more trend is present or the more it resembles the actual time series.

Exponential Smoothing 1200 1000 800 Actual Price 600 Alpha=0.1 400 Alpha=0.3 Alpha=0.8 200 0 0 1 2 3 4 5 8 9 10 11 12 6 7 Per

Hence, The pink ( diamond symbol ) line is the "forecast that uses 0.2 smoothing parameter"

Add a comment
Know the answer?
Add Answer to:
1. Smoothing methods (conceptual) Aa Aa Monthly time series data on coin collections from about 70,000...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Consider the following time series data.

    Please help :) a. Which of the following is a correct time series plot for this data? b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary).  c. Use α-.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for month 8 (to 2 decimals). Enter negative values as negative number.  d. Compare the three-month moving average approach with the exponential smoothing approach using...

  • (1) Explain smoothing methods in time series. How to find the opti- mal value of the...

    (1) Explain smoothing methods in time series. How to find the opti- mal value of the smoothing parameter in an exponentially weighted moving average. (2) Prove that ARCH(1) process is leptokurtic. Also establish its equiv- alence to AR process. (3) Prove that exponentially weighted moving average model is a special case of GARCH(1,1) processes. Also establish its equivalence to ARMA(1,1) process. (4) Find the minimum mean square error (MMSE) forecast of AR(2) process and then obtain the variance of the...

  • Omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a....

    omework Consider the following time series data Month 1 2 3 4 5 6 7 Value 21 14 18 13 18 21 14 a. Which of the following is a correct time series plot for this data? や" -Select your answer- What type of pattern exists in the data? -select your answer- b. Develop the three-month moving average forecasts for this time series. Compute MSE and a forecast for month 8 (to 2 decimals if necessary). Enter negative values as...

  • Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Consider the following time series data: Month 1...

    Problem 08-06 Algo (Moving Averages and Exponential Smoothing) Consider the following time series data: Month 1 2 3 4 5 6 7 Value 23 13 21 13 19 21 17 (a) Choose the correct time series plot Month (iv) Month Select your answer What type of pattern exists in the data? Select your answer- (b) Develop a three-month moving average for this time series. Compute MSE and a forecast for month 8. If required, round your answers to two decimal...

  • Consider five years of monthly sales data for a company in the attached file (Q5.xlsx). a) Foreca...

    Consider five years of monthly sales data for a company in the attached file (Q5.xlsx). a) Forecast monthly sales for the next year (2020). (10 marks) b) Discuss whether a simple exponential smoothing model works well with this data or not. (5 m 7 9 Month Sales 747 Feb-14 697 Mar-14 1014 Jan-14 Ap4 1126 May-14 1105 Jun-14 1450 Jul-14 1633 Aug-14 1711 Sep-14 1307 Oct-1223 Nov-14 9T5 Dec-14S53 4J-15 1024 Feb-15928 Mar-151442 7Apr-151371 May-15 1536 Ju15 2004 Jul-15 1854...

  • Please help Consider the following time series data. Week 1 N 3 4 5 6 Value...

    Please help Consider the following time series data. Week 1 N 3 4 5 6 Value 19 11 13 10 14 12 (a) Construct a time series plot. 20 18 20 18 14 12 10 Week 3 4 Week D 20 18+ 16 Time Series Value Time Series Value 5 Week 0 Wook What type of pattem exists in the data? The data appear to follow a cyclical pattern. The data appear to follow a trend pattem. The data appear...

  • Consider the following data: Monthly Profit of an Auto Repair Shop Month Jan-14 Feb-14 Mar-14 Apr-14...

    Consider the following data: Monthly Profit of an Auto Repair Shop Month Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Profit ($) 16,416 16,566 15,355 17,420 19,063 17,240 19,138 18,501 20,290 Step 3 of 4 : Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.30 . If necessary, round your answer to one decimal place.

  • Key Objective: Crusty Pizza Executives must forecast December sales for the 10 stores in worksheet “Time Series”. Use d...

    Key Objective: Crusty Pizza Executives must forecast December sales for the 10 stores in worksheet “Time Series”. Use data in worksheet “Time Series”. Plot the data for each store. Develop a sales forecast for each of the 10 stores for the month of December, using: A three month moving average A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month. Exponential smoothing with an alpha value of 0.25. Assume...

  • The monthly sales for Yazici Batteries, Inc., were as follows:

    The monthly sales for Yazici Batteries, Inc., were as follows:                                                                                                                                        Month Jan       Feb      Mar     Apr      May     Jun       Jul        Aug      Sept     Oct      Nov      DecSales    19        21        17        14        11        18        16        19        20        20        23        23b) The forecast for the next month (Jan) using the naive method (round your response to a whole number)The forecast for the next period (Jan) using a 3-month moving average approach =(round your response to two decimal places)The forecast for the next period (Jan) using a 6-month weighted average with weights ofandwhere the heaviest weights are applied to the most recent month = (round your response to one decimalplace)Using...

  • Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Whic...

    Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Which of the following is a correct time series plot for this data? - Select your answer -plot #1plot #2plot #3Item 1 What type of pattern exists in the data? - Select your answer -VerticalHorizontalScatterItem 2 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week  (to 2 decimals if necessary)....

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT