Let us consider the following time series: Year 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Sales 119 126 133 142 153 168 189 202 185 149 (a) Write down the use of moving average method. Apply a 3 year moving average (MA) method to find the trend for the following above time series. (b) Suppose the least squares estimate for the above times series is : Yˆ(t) = 123 + 3.8X(t), where Y (t)= sale and X(t)=time. Obtain the forecasted average sale for year 2009 and 2012. Explain for which year the forecasting error/uncertainity would be lower? and why? (c) What is the motivation of weighting in the exponential moving average methods?

Let us consider the following time series: Year 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 Sales 119 126 133 142 153 168 189 202 185 149 (a) Write down the use of moving average method. Apply a 3 year moving average (MA) method to find the trend for the following above time series. (b) Suppose the least squares estimate for the above times series is : Yˆ(t) = 123 + 3.8X(t), where Y (t)= sale and X(t)=time. Obtain the forecasted average sale for year 2009 and 2012. Explain for which year the forecasting error/uncertainity would be lower? and why? (c) What is the motivation of weighting in the exponential moving average methods?

Algebra & Trigonometry with Analytic Geometry

13th Edition

ISBN:9781133382119

Author:Swokowski

Publisher:Swokowski

Chapter10: Sequences, Series, And Probability

Section10.2: Arithmetic Sequences

Problem 68E

See similar textbooks

Similar questions

1. Consider the following time series: a. Construct a time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.
Using simple moving averages and the following time series data, respond to each of the items. Period Demand 1 130 2 122 3 121 4 112 5 143 6 105 7 116 8 118 9 142 10 125 b. Compute all possible forecasts using a six-period simple moving average model. (Round your answers to 1 decimal place.) Period Demand 6-Period SMA Absolute Error 1 130 0.0 0.0 2 122 0.0 0.0 3 121 0.0 0.0 4 112 0.0 0.0 5 143 0.0 0.0 6 105 0.0 0.0 7 116…
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1 16 2 20 3 20 4 23 5 18 6 17 8 19 9 23 10 19 11 14 12 21 a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and 1/6 the most recent observation, compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers. Week Time-Series Value Weighted MovingAverage Forecast ForecastError (Error)2 1 2 3 4 5 6 7 8 9 10 11 12 Total b. Compute the MSE for the weighted moving average in part (a).MSE = Do you prefer this weighted moving average to the unweighted moving average? Remember that…
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 25 14 21 13 20 24 16 (a) Construct a time series plot. -A time series plot contains a series of 7 points connected by line segments. The horizontal axis ranges from 0 to 8 and is labeled: Month. The vertical axis ranges from 0 to 30 and is labeled: Time Series Value. The points are plotted from left to right at regular increments of 1 month starting at month 1. The points appear to vary randomly between 8 to 20 on the vertical axis. The plot reaches its maximum time series value at month 1. -A time series plot contains a series of 7 points connected by line segments. The horizontal axis ranges from 0 to 8 and is labeled: Month. The vertical axis ranges from 0 to 30 and is labeled: Time Series Value. The points are plotted from left to right at regular increments of 1 month starting at month 1. The points appear to vary randomly between 8 to 20 on the vertical axis. The plot reaches its maximum time…
Consider the following time series data. Month 1 2 3 4 5 6 7 Value 23 12 19 11 18 22 14 (a) Construct a time series plot. A time series plot contains a series of 7 points connected by line segments. The horizontal axis ranges from 0 to 8 and is labeled: Month. The vertical axis ranges from 0 to 30 and is labeled: Time Series Value. The points are plotted from left to right at regular increments of 1 month starting at month 1. The points appear to vary randomly between 6 to 18 on the vertical axis. The plot reaches its maximum time series value at month 1. A time series plot contains a series of 7 points connected by line segments. The horizontal axis ranges from 0 to 8 and is labeled: Month. The vertical axis ranges from 0 to 30 and is labeled: Time Series Value. The points are plotted from left to right at regular increments of 1 month starting at month 1. The points appear to vary randomly between 11 to 23 on the vertical axis. The plot reaches its maximum time…
Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week. Sales (1000s of gallons) 1 16 2. 22 3. 18 4. 23 5. 18 6. 17 7 21 8 17 9 21 10. 21 11 14 12 23 Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and third the most recent observation, 1/6 compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers. Week Time-Series Value Weighted MovingAverage Forecast ForecastError (Error)2 Total b.…
The owner of Showtime Movie Theaters, Inc., would like to predict weekly gross revenue as a function of advertising expenditures. Historical data for a sample of eight weeks follow. Weekly Gross Revenue ($1000s) Televison Advertising ($1000s) Newspaper Advertising ($1000s) 97 6 2.5 90 2 2 96 5 1.5 92 2.5 3.5 96 4 4.3 94 3.5 2.3 94 2.5 5.2 94 3 3.5 a. Use a = 0.01 to test the hypotheses Ho: B1 = B2 = 0 Ha: B1, and/or B2 is not equal to zero for the model y=Bo + B1X1 + B2X2 + E, where x1= television advertising ($1,000s) x2= newspaper advertising (1,000s) Compute the test statistic (to 2 decimals). Use F table. __________ b. Use a = 0.05 to test the significance of B1. Compute the t test statistic (to 2 decimals). Use t table. ____________ c. Use a = 0.05 to test the significance of B2. Compute the test statistic (to 2 decimals). Use t table. _______________
1. Suppose that X1, Xn is an iid random sample from a distribution with pdf f(x; sigma) = 1/2 * (sigma) * e ^ (- |x| / sigma) - infinity0 0(a) Find the method of moments estimator (MME) of \sigma. Hint: See the example in lecture notes. (b) Find the maximum likelihood estimator (MLE) of \sigma. Hint: See the example in lecture notes. (c) Use central limit theorem to find the large - sample asymptotic distribution of the MLE in part (b). (d) Suppose 10 independent observations were taken from the given distribution: (0.5, 0.8, 2.2, 1.6, 2.0, 2.8, 1.5, 0.9, 2.5, 1.8). What is the numerical value of the MLE? What is the numerical value of the estimated standard deviation (standard error) of the MLE?
The following data set provides the total number of shipments of core major household appliances in the U.S. from 2000 to 2016 (in millions): Year Shipments (millions) 2000 38.4 2001 38.2 2002 40.8 2003 42.5 2004 46.1 2005 47.0 2006 46.7 2007 44.1 2008 39.8 2009 36.5 2010 38.2 2011 36.0 2012 35.8 2013 39.2 2014 41.5 2015 42.9 2016 44.7 a. Plot the time series. b. Fit a three-year moving average to the data and plot the results. c. Fit a five-year moving average to the data and plot the results. d. Compute a linear trend forecasting equation and plot the trend line. e. Compute a quadratic trend forecasting equation and plot the results.
#4) Commuter ridership in Athens, Greece, during the summer months is believed to be heavily tied to the number of tourists visiting the city. During the past 12 years, the data are given in the following table. Year Number of Tourists (millions) Ridership (hundreds of thousands) 1 6 11 2 11 16 3 8 16 4 10 14 5 19 28 6 18 26 7 16 21 8 20 25 9 24 45 10 18 28 11 11 18 12 19 35 a) Create a time series plot for the ridership. b) Using linear regression to see if using the year is a good predictor for the ridership. What is the regression equation? How accurate is the model? c) Using linear regression to see if using the number of tourists is a good predictor for the ridership. What is the regression equation? How accurate is the model? d) Which linear regression equation is better? What is the expected ridership if 10 million tourists visit the city next year? e) Excel File
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 18 15 (a) Construct a time series plot. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 10 to 17 on the vertical axis. The plot reaches its maximum time series value at week 6. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 12 to 19 on the vertical axis. The plot reaches its maximum time series value at…
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 14 17 12 18 15 (a) Construct a time series plot. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 10 to 17 on the vertical axis. The plot reaches its maximum time series value at week 6. A time series plot contains a series of 6 points connected by line segments. The horizontal axis ranges from 0 to 7 and is labeled: Week. The vertical axis ranges from 0 to 20 and is labeled: Time Series Value. The points are plotted from left to right in regular increments of 1 week starting at week 1. The points appear to vary randomly between 12 to 19 on the vertical axis. The plot reaches its maximum time series value at…