Question

In: Statistics and Probability

With the gasoline time series data from the given table, show the exponential smoothing forecasts using...

With the gasoline time series data from the given table, show the exponential smoothing forecasts using α = 0.1.

week 1 2 3 4    5 6 7 8 9 10 11 12

sales 17 21 19 23 18 16 20 18 22 20 15 22  

a.

Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of α = 0.1 or α = 0.2 for the gasoline sales time series? Do not round your interim computations and round your final answers to three decimal places.

MSE

a=0.1 --- ( )

a = 0.2 --( )

Which is Preffered?

B.Are the results the same if you apply MAE as the measure of accuracy? Do not round your interim computations and round your final answers to three decimal places.

MAE

a=0.1 --- ( )

a = 0.2 --( )

Which is preffered?

C. What are the results if MAPE is Used? Do not round your interim computations and round your final answers to two decimal places.

MAPE

a=0.1 --- ( )%

a = 0.2 -- ( )%

Which is preffered?

Solutions

Expert Solution

Solution :

Thank You.

Please don't forget to like.


Related Solutions

a) Use α = 0.2 to compute the exponential smoothing forecasts for the time series.
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 11 13 10 14 12 a) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 18 2 11 ? 3 13 ? 4 10 ? 5 14 ? 6 12 ? Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two...
a) Use α = 0.2 to compute the exponential smoothing forecasts for the time series.
Consider the following time series data. Week 1 2 3 4 5 6 Value 18 11 13 10 14 12 a) Use α = 0.2 to compute the exponential smoothing forecasts for the time series. Week Time Series Value Forecast 1 18 2 11 ? 3 13 ? 4 10 ? 5 14 ? 6 12 ? Compute MSE. (Round your answer to two decimal places.) MSE = What is the forecast for week 7? (Round your answer to two...
Refer to the gasoline sales time series data in the given table.
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 17 2 21 3 19 4 24 5 19 6 15 7 21 8 19 9 23 10 19 11 15 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 17     2 21     3 19     4 24    ...
Refer to the gasoline sales time series data in the given table.
Refer to the gasoline sales time series data in the given table. a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places.b. Compute the MSE for the four-week and five-week moving average forecasts. Round your intermediate calculations and final answers to two decimal places. MSE for four-week moving average = MSE for five-week moving average = c. What appears to be the best number of weeks of past data (three, four, or five) to use in...
Refer to the gasoline sales time series data in the given table. Click on the datafile...
Refer to the gasoline sales time series data in the given table. Click on the datafile logo to reference the data. Week Sales (1,000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (a) Compute four-week and five-week moving averages for the time series.   If required, round your answers to two decimal places.   Week Sales 4 PeriodMoving Average 5 periodMoving Average...
a. Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.
Month137244335450534630750829936103511411245a.  Show the naive forecast, an exponential smoothing forecasts using α = 0.2, and a 3-month moving average forecast.b. Compare the MFE, MSE, and MAPE on the modelsc.  Make a conclusion on which model to use.d. Find the alpha (smoothing constant) that minimizes the MSE.
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 18 2 22 3 15 4 24 5 18 6 15 7 21 8 19 9 21 10 20 11 16 12 22 Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 period Moving Average 1 18 2 22 3 15 4 24 5 18...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 18 2 22 3 15 4 24 5 18 6 15 7 21 8 19 9 21 10 20 11 16 12 22 (a) Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 period Moving Average 1 18 2 22 3 15 4 24 5...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1000s of gallons) 1 18 2 22 3 18 4 24 5 19 6 16 7 21 8 19 9 22 10 19 11 16 12 23 Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. Week Sales 4-Week Moving Average 5-Week Moving Average 1 18 2 22 3 18 4 24 5 19 6 16 7 21...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of...
Refer to the gasoline sales time series data in the given table. Week Sales (1,000s of gallons) 1 17 2 21 3 19 4 23 5 18 6 16 7 20 8 18 9 22 10 20 11 15 12 22 (a) Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. Week Sales 4 Period Moving Average 5 period Moving Average 1 17 2 21 3 19 4 23 5...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT