Question

With the gasoline time series data from the given table, show the exponential smoothing forecasts using a = 0.1. GASOLINE SALThe options for prefer for A B and C are 0.1 or 0.2

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

For Alpha=0.1 the calculations are shown as

17 17 17 - 17 = 0 (17- 17) = 0 17-11= 0% 21-17 21 17 21 - 17 = 4 19.05% (21 - 17) = 16 (19- 17.4) = 2.56 19 17.4 19 - 17.4 =

For alpha = 0.2 the calculation is shown as

Data ES(0.2) Forecasts Abs. Error Error2 Abs. % Error 17 17 17 - 17 = 0 12 = 0% (17- 17) = 0 21 - 17) = 16 21 - 17 = 21 17 4

MAE a=0.1 MSE 8.48 MAPE 11.87 2.35 æ0.2 2.38 8.23 2-29 acc tee MS @=0.2 ace tee MAE a=0.1 pro. I acc ta MAPE

Add a comment
Know the answer?
Add Answer to:
The options for prefer for A B and C are 0.1 or 0.2 With the gasoline...
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
  • use the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week...

    use the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) 0.1, and a -0.2. (a) Show the exponential smoothing forecasts using a Exponential Smoothing Week a = 0.1 -0.2 (b) Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of a 0.1 or 0.2 for the gasoline sales time series? An - Select your answer- smoothing constant provides the more accurate forecast, with an overall MSE...

  • business analytics Consider the following gasoline sales time series. If needed, round your answers to two-decimal...

    business analytics Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) (a) Show the exponential smoothing forecasts using a -0.1, and 0.2 Exponential Smoothing 9 = 0.1 0 = 0.2 Week (b) Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of a 0.1 or 0 - 0.2 for the gasoline sales time series? An - Select your answer- smoothing constant provides the more accurate...

  • GASOLINE SALES TIME SERIES Sales (1000s of gallons) Week 21 19 5 18 6 16 7...

    GASOLINE SALES TIME SERIES Sales (1000s of gallons) Week 21 19 5 18 6 16 7 20 18 22 10 20 11 15 12 22 show the exponential smoothing forecasts using a = 0.1 a. Applying the MSE measure of forecast accuracy, would you prefer a smoothing constant of a 2 for the gasoline sales time series (to 2 decimals)? .1 or a MSE for a = 1 MSE for a = 2 Select b. Are the results the same...

  • Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week...

    Consider the following gasoline sales time series. If needed, round your answers to two-decimal digits. Week Sales (1,000s of gallons) 1 17 2 21 3 16 4 24 5 17 6 18 7 22 8 20 9 21 10 19 11 16 12 25 (a) Show the exponential smoothing forecasts using α = 0.1, and α = 0.2. Exponential Smoothing Week α = 0.1 α = 0.2 13 (b) Applying the MSE measure of forecast accuracy, would you prefer a...

  • Please help. I'm stuck. DATA: Gassins These data show the number of palons of gasoline sold...

    Please help. I'm stuck. DATA: Gassins These data show the number of palons of gasoline sold by a gasoline distributor in Bennington, Vermont, over Week Sales (1.000s of gallons) 1 17 21 N 3 19 4 22 5 18 6 16 2 20 8 18 9 22 10 20 11 15 12 22 Show the exponential smoothing forecasts using a=0.1. (Round your answers to two decimal places.) Time Series Value Forecast Week 1 17 2. 21 19 23 5 18...

  • Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. 1...

    Problem 15-07 (Algorithmic) Refer to the gasoline sales time series data in the given table. 1 Week Sales (1000s of gallons) 17 2 20 21 11 14 22 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Moving Average Moving Average Week Sales 17 9 10 11 12 17 DE 23 21 C C 14 22 b. Compute the MSE for the four-week and five-week moving average forecasts. Round...

  • Refer to the gasoline sales time series data in the given table. Sales (1000s of gallons)...

    Refer to the gasoline sales time series data in the given table. Sales (1000s of gallons) 18 Week 18 24 17 15 20 17 21 20 14 4 8 10 12 a. Compute four-week and five-week moving averages for the time series. Round your answers to two decimal places. 4-Week 5-Week Sales Moving Average Moving Averagee 18 18 24 17 15 20 17 21 20 14 10 12 b. Compute the MSE for the four-week and five-week moving average forecasts....

  • Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6...

    Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 18 14 16 11 17 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: Mean absolute error (MAE) Mean squared error (MSE) Mean absolute percentage error (MAPE) Round your answers to two decimal places. MAE = MSE = MAPE = Using the average of all the historical data as a...

  • PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT...

    PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT IS FILLED OUT ALREADY. THANK YOU! Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 1914 16 10 17 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error (MAE) b. Mean squared error (MSE) c. Mean absolute percentage error...

  • 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...

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