Question

(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average.Gasoline Sales Time Series Sales (000s of gallons) Week 17 21 2 19 3 23 4 18 16 6 20 18 8 9 20 10 15 12○ 2.50 ○ 2.62 О 3.00 О 2.67

(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average.
Gasoline Sales Time Series Sales (000's of gallons) Week 17 21 2 19 3 23 4 18 16 6 20 18 8 9 20 10 15 12
○ 2.50 ○ 2.62 О 3.00 О 2.67
0 0
Add a comment Improve this question Transcribed image text
Answer #1

The table for calculation will be:

Data Forecast Deviation Absolute Deviation 17 21 19 23 18 16 20 18 19 21 20 19 18 18 20 20 19 4 4 4 C) 4 C) C) 4 C) 20 1%

Hence,

Mean absolute deviation = (4 + 3 + 4 + 1 + 0 + 4 + 0 + 5 + 3)/9 = 2.67

Option D is correct.

Add a comment
Know the answer?
Add Answer to:
(CO 2) Using the table Gasoline Sales Time Series, calculate the mean absolute deviation for a 3-day moving average. Gasoline Sales Time Series Sales (000's of gallons) Week 17 21 2 19 3 23 4 18...
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
  • 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....

  • Sales (1000s of gallons) 18 Week 19 23 17 16 20 17 23 19 10 12...

    Sales (1000s of gallons) 18 Week 19 23 17 16 20 17 23 19 10 12 a. Compute four-week and five-week moving averages for the time series. If required, round your answers to two decimal places. 4 Period Period Moving ge Average Moving Averag WeekSales 18 19 23 17 16 19.6x 20.25 V 1911 19.4| 20 19.2x 19.25x 23 18.81 × 1019 1918.8 19.2x 11 14 20 ]X 18.75 12 b. Compute the MSE for the four-week and five-week moving...

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

  • Week Sales (100s of gallons) 1 18 2 22 3 19 4 24 5 17 6...

    Week Sales (100s of gallons) 1 18 2 22 3 19 4 24 5 17 6 16 7 21 8 19 9 23 10 21 11 15 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 for the third most recent observation, compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers. b. compute the MSE for the...

  • Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in...

    Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Week Sales (1,000s of gallons) 1 17 2 22 3 20 4 24 5 18 6 17 7 21 8 19 9 23 10 21 11 16 12 22 (a) Compute four-week and five-week moving averages for the time series. Week Time Series Value 4-Week Moving Average Forecast 5-Week Moving Average Forecast 1 17 2 22 3...

  • 1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks...

    1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...

  • 1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE...

    1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...

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

  • Consider the following gasoline sales time series data. Click on the datafile logo to reference the...

    Consider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week Sales (1000s of gallons) 1     17    2     20    3     19    4     23    5     18    6     16    7     19    8     18    9     23    10     19    11     15    12     22    a. Using a weight of  for the most recent observation,  for the second most recent observation, and  third the most recent observation, compute a three-week...

  • Check My Work (3 remaining Consider the following gasoline sales time series data. Click on the d...

    Check My Work (3 remaining Consider the following gasoline sales time series data. Click on the datafile logo to reference the data Week Sales (1000s of gallons) 20 18 17 19 21 12 a. Using a weight of for the most recent observation, for the second most recent observation, and third the most recent abaervation, compute a threa-week weightad moving avarage fos the time series (to 2 decimals). Enter nagative values as negative numbers Weighted Moving Average Forecast (Error Time-Series...

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