Refer again to the gasoline sales time series data in the following table. Sales (1000s of gallons) 18 24 19 24 17 16 22 19 24 21 16 22 Week 1 2 3 4 5 6 7 8 9 10 11 12 a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Use rounded for two decimal places values for intermed calculations. Use minus sign for negative values. Week 1 2 3 4 5 6 7 8 9 10 11 12 Sales 18 24 19 24 17 16 22 19 24 21 16 22 Weighted Moving Average Forecast Forecast Error Total 1 I I 1 (Error)2

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter10: Statistics
Section10.5: Comparing Sets Of Data
Problem 14PPS
icon
Related questions
Question

Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Use rounded for two decimal places values for intermediate calculations. Use minus sign for negative values.

Refer again to the gasoline sales time series data in the following table.
Week
1
2
3
4
5
6
7
8
9
10
11
12
Week
1
2
3
5
6
7
8
9
10
11
12
Sales
18
24
19
24
17
a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Use rounded for two decimal places values for intermediate
calculations. Use minus sign for negative values.
16
22
19
24
21
16
Sales (1000s of gallons)
22
18
NA NANGN
24
19
24
17
16
22
19
24
21
16
22
Weighted Moving
Average Forecast
Forecast
Error
Total
(Error)²
Transcribed Image Text:Refer again to the gasoline sales time series data in the following table. Week 1 2 3 4 5 6 7 8 9 10 11 12 Week 1 2 3 5 6 7 8 9 10 11 12 Sales 18 24 19 24 17 a. Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent, and 1/6 for third most recent, compute a three-week weighted moving average for the time series. Use rounded for two decimal places values for intermediate calculations. Use minus sign for negative values. 16 22 19 24 21 16 Sales (1000s of gallons) 22 18 NA NANGN 24 19 24 17 16 22 19 24 21 16 22 Weighted Moving Average Forecast Forecast Error Total (Error)²
Expert Solution
steps

Step by step

Solved in 4 steps with 8 images

Blurred answer
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Trigonometry (MindTap Course List)
Trigonometry (MindTap Course List)
Trigonometry
ISBN:
9781305652224
Author:
Charles P. McKeague, Mark D. Turner
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL