Question

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 tim

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

1 Week 4 period moving 5 period moving 18 Sales 23 17 16 20 17 23 19 5 20.5 20.25 18.75 19 17.5 19.8 19.4 9 10 18.6 18.6 19 1Error 2 5 period moving Error 18 Sales 39 Week 40 2 19 23 17 16 20 17 23 19 14 42 4 5 6 43 14.44 0.36 4 19.36 0.16 25 11.56 7

Add a comment
Know the answer?
Add Answer to:
Sales (1000s of gallons) 18 Week 19 23 17 16 20 17 23 19 10 12...
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....

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

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

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

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

  • 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 time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a ...

    Consider the following time series data. Week 1 2 3 4 5 6 Value 19 11 16 1017 15 (a) Construct a time series plot. 20 20 20 18 16 14 12 10 c 14 12 12 0 23 4 5 67 0 23 4 5 67 Week Weck Week 20 18 0 1 2345 6 7 Week What type of pattern exists in the data? The data appear to follow a seasonal pattern. The data appear to follow a...

  • help with D July August September October 19 22 23 17.50 18.50 19 20.25 15+20+18-17=70/4-17.50 20+18+17+19=74/4-18.50...

    help with D July August September October 19 22 23 17.50 18.50 19 20.25 15+20+18-17=70/4-17.50 20+18+17+19=74/4-18.50 18+17+19+22=76/4-19 17+19+22+23=81/20.25 C) six months average 19 18 January February March April May June July August September October 19 22 23 17.83 19+18+15+20+18+17=107/6=17.83 17.83 18+15+20+18+17+19=107/617.83 18.50 15+20+18+17+19+22-111/618.50 19.83 20+1817+19+22+23-119/619.83 D) a three-month weighted average using 60 for the prior month, 30 for 2 months prior, and 10 for three months prior 113 words English (United States

  • 1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452...

    1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...

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