Question

In: Statistics and Probability

(a) Construct a time series plot. (b)Develop the three-week moving average forecasts for this time series.

Consider the following time series data.

Week 1 2 3 4 5 6
Value 17 12 14 10 16 13

(a) Construct a time series plot.

(b)Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.)

Week Time Series
Value
Forecast
1 17
2 12
3 14
4 10
5 16
6 13

Compute MSE. (Round your answer to two decimal places.)

MSE =

What is the forecast for week 7?

(c) Use α = 0.2 to compute the exponential smoothing forecasts for the time series.

Week Time Series
Value
Forecast
1 17
2 12
3 14
4 10
5 16
6 13

Compute MSE. (Round your answer to two decimal places.)

MSE =

What is the forecast for week 7? (Round your answer to two decimal places.)

(d) Compare the three-week moving average approach with the exponential smoothing approach using α = 0.2.

Which appears to provide more accurate forecasts based on MSE? Explain.

The three-week moving average provides a better forecast since it has a smaller MSE than the smoothing approach.

The three-week moving average provides a better forecast since it has a larger MSE than the smoothing approach.    

The exponential smoothing using α = 0.2 provides a better forecast since it has a smaller MSE than the three-week moving average approach.

The exponential smoothing using α = 0.2 provides a better forecast since it has a larger MSE than the three-week moving average approach.

(e) Use a smoothing constant of α = 0.4 to compute the exponential smoothing forecasts.

Week Time Series
Value
Forecast
1 17
2 12
3 14
4 10
5 16
6 13

Solutions

Expert Solution

a)]

b)

Time period Actual Value(A) Moving avg. Forecast(F) Forecast error E=|A-F| Squared Forecast Error MAPE
1 17
2 12
3 14
4 10 14.33 4.33 18.78 0.4333
5 16 12.00 4.00 16.00 0.2500
6 13 13.33 0.33 0.11 0.0256
Total 8.67 34.89 0.2756
Average 2.89 11.63 13.78%
MAD MSE MAPE
MSE = 11.63
forecast for week 7 = 13.00

c)

for exponential smoothing: next period forecast =α*last period actual+(1-α)*last period forecast
Time period Actual Value(A) Forecast(F)
1 17
2 12 17.00
3 14 16.00
4 10 15.60
5 16 14.48
6 13 14.78
MSE = 13.17
forecast for week 7 = 14.42

d)

The three-week moving average provides a better forecast since it has a smaller MSE than the smoothing approach.

e)

Time period Actual Value(A) Forecast(F)
1 17
2 12 17.00
3 14 15.00
4 10 14.60
5 16 12.76
6 13 14.06

Related Solutions

Develop the three-week moving average forecasts for this time series.
Consider the following time series data. Week 1 2 3 4 5 6 Value 17 11 14 10 16 13 (a) (b) Develop the three-week moving average forecasts for this time series. (Round your answers to two decimal places.) Week Time Series Value Forecast 1 17 2 11 3 14 4 10 5 16 6 13 Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (c) Use α = 0.2 to...
b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 17 11 17 15 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary). MSE The forecast for week 7 c. Use a=.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 7 (to 2 decimals). MSE The forecast for week d....
Develop a three-week moving average for this time series. Compute MSE and a forecast for week...
Develop a three-week moving average for this time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places. Week Time SeriesValue Forecast 1 18   2 13   3 16   4 11   5 17   6 14   MSE :The forecast for week 7 :Use = 0.2 to compute the exponential smoothing values for the time series. Compute MSE and a forecast for week 7. Round your answers to two decimal places....
(a) Develop a three-year moving average. (b) Develop a four-year moving average.
Question 1 Sales for the Forever Young Cosmetics Company (in $ millions) are as follows: Year Sales ($ millions) Year Sales ($ Millions) Year Sales ($ Milions 1996 2.4 2003 4.4 2010 4.5 1997 2.7 2004 4.8 2011 4.8 1998 3.3 2005 5.1 2012 5.1 1999 4.6 2006 5.3 2013 5.5 2000 3.2 2007 5.2 2014 5.7 2001 3.9 2008 4.6 2002 4 2009 4.5 (a) Develop a three-year moving average. (b) Develop a four-year moving average. (c) Develop a...
Construct a time series plot. What type of pattern exists in the data?
Consider the following time series data. Quarter Year 1 Year 2 Year 3 1 4 6 7 2 2 3 6 3 3 5 6 4 5 7 8 Construct a time series plot. What type of pattern exists in the data? The time series plot indicates a linear trend and a seasonal pattern Show the four-quarter and centered moving average values for this time series.   Compute seasonal indexes and adjusted seasonal indexes for the four quarters.
7. Construct a time series plot. Comment on what type of pattern exists in the data....
7. Construct a time series plot. Comment on what type of pattern exists in the data. Use a regression model with dummy variables as follow to explain sales: Qtr1 = 1 if quarter 1, 0 otherwise; Qtr2 = 1 if quarter 2, 0 otherwise; Qtr3 = 1 if quarter 3, 0 otherwise. Write out the model that you’ve estimated in equation form using the values of your estimates. Explain, in a sentence or two, what this model tells us. Use...
develop a? three-period moving average forecast for april 2019
A geneticist discovers a new mutation in Drosophila melanogaster that causes the flies to shake and quiver. She calls this mutation spastic (sps) and determines that it is due to an autosomal recessive gene. She wants to determine if the gene encoding spastic is linked to the recessive gene for vestigial wings (vg). She crosses a fly homozygous for spastic and vestigial traits with a fly homozygous for the wild-type traits and then uses the resulting F1 females in a...
Consider the following time series.   (a) Choose the correct time series plot.     (i)...
Consider the following time series.   (a) Choose the correct time series plot.     (i) (ii) (iii) (iv)     - Select your answer -Plot (i)Plot (ii)Plot (iii)Plot (iv)Item 1     What type of pattern exists in the data?   - Select your answer - Horizontal PatternDownward Trend PatternUpward Trend PatternItem 2     (b) Use simple linear regression analysis to find the parameters for the line that minimizes MSE for this time series.       Do...
Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.
  Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 21 3 19 4 22 5 18 6 16 7 20 8 19 9 23 10 19 11 16 12 22 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-WeekMoving Average 5-WeekMoving Average 1 18     2 21     3 19     4 22  ...
Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary).
Quarter Year 1 Year 2 Year 3 1 4 6 8 2 2 4 7 3 3 5 6 4 5 7 8 Show the four-quarter and centered moving average values for this time series (to 3 decimals if necessary). Year Quarter Time Series Value Four-Quarter Moving Average Centered Moving Average 1 1 4 2 2 3 3 4 5 2 1 6 2 4 3 5 4 7 3 1 8 2 7 3 6 4 8 Compute seasonal...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT