onsider the following gasoline sales time series data. Click on the datafile logo to reference the data. Week.           Sales (1000s of gallons) 1                    16 2.                   22 3.                  18 4.                  23 5.                  18 6.                  17 7                   21 8                   17 9                   21 10.                21 11                  14 12                  23

Calculus For The Life Sciences
2nd Edition
ISBN:9780321964038
Author:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Chapter1: Functions
Section1.EA: Extended Application Using Extrapolation To Predict Life Expectancy
Problem 2EA
icon
Related questions
Question

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

Week.           Sales (1000s of gallons)

1                    16

2.                   22

3.                  18

4.                  23

5.                  18

6.                  17

7                   21

8                   17

9                   21

10.                21

11                  14

12                  23

Using a weight of 1/2 for the most recent observation, 1/3 for the second most recent observation, and  third the most recent observation, 1/6 compute a three-week weighted moving average for the time series (to 2 decimals). Enter negative values as negative numbers.

 


Week

Time-Series Value
Weighted Moving
Average Forecast
Forecast
Error
 
(Error)2
             
             
             
             
             
             
             
             
             
             
             
             
          Total  

 

b. Compute the MSE for the weighted moving average in part (a).
MSE =  

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Time Series Analyses, Forecasting Methods, and Indices
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Functions and Change: A Modeling Approach to Coll…
Functions and Change: A Modeling Approach to Coll…
Algebra
ISBN:
9781337111348
Author:
Bruce Crauder, Benny Evans, Alan Noell
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
College Algebra
College Algebra
Algebra
ISBN:
9781938168383
Author:
Jay Abramson
Publisher:
OpenStax
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Big Ideas Math A Bridge To Success Algebra 1: Stu…
Algebra
ISBN:
9781680331141
Author:
HOUGHTON MIFFLIN HARCOURT
Publisher:
Houghton Mifflin Harcourt
Holt Mcdougal Larson Pre-algebra: Student Edition…
Holt Mcdougal Larson Pre-algebra: Student Edition…
Algebra
ISBN:
9780547587776
Author:
HOLT MCDOUGAL
Publisher:
HOLT MCDOUGAL