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 18 2 22 3 20 4 24 5 19 6 17 7 22 8 20 9 24 10 22 11 17 12 24 (a) Using a weight of  1 2 for the most recent observation,  1 3 for the second most recent observation, and  1 6 for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.) Week Time Series Value Weighted Moving Average Forecast 1 18   2 22   3 20   4 24   5 19   6 17   7 22   8 20   9 24   10 22   11 17   12 24   (b) Compute the MSE for the weighted moving average in part (a). MSE =  Do you prefer this weighted moving average to the unweighted moving average? The MSE for the unweighted moving average is 10.91. The unweighted moving average is preferred because it has a larger MSE compared to the weighted moving average.The unweighted moving average is preferred because it has a smaller MSE compared to the weighted moving average.    The weighted moving average is preferred because it has a larger MSE compared to the unweighted moving average.The weighted moving average is preferred because it has a smaller MSE compared to the unweighted moving average. (c) Suppose you are allowed to choose any weights as long as they sum to 1. Could you always find a set of weights that would make the MSE at least as small for a weighted moving average than for an unweighted moving average? Why or why not? No, an unweighted moving average always has a smaller MSE than a weighted moving average.Yes, because an unweighted moving average is just a weighted moving average where the weights are equal.    No, sometimes you need to let the weights sum to a number higher/lower than 1 in order to get a smaller MSE than the one for an unweighted moving average.Yes, a weighted moving average always has a smaller MSE than an unweighted moving average.

MATLAB: An Introduction with Applications
6th Edition
ISBN:9781119256830
Author:Amos Gilat
Publisher:Amos Gilat
Chapter1: Starting With Matlab
Section: Chapter Questions
Problem 1P
icon
Related questions
Question
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 18
2 22
3 20
4 24
5 19
6 17
7 22
8 20
9 24
10 22
11 17
12 24
(a)
Using a weight of 
1
2
 for the most recent observation, 
1
3
 for the second most recent observation, and 
1
6
 for third most recent observation, compute a three-week weighted moving average for the time series. (Round your answers to two decimal places.)
Week Time Series
Value
Weighted Moving
Average Forecast
1 18  
2 22  
3 20  
4 24  
5 19  
6 17  
7 22  
8 20  
9 24  
10 22  
11 17  
12 24  
(b)
Compute the MSE for the weighted moving average in part (a).
MSE = 
Do you prefer this weighted moving average to the unweighted moving average? The MSE for the unweighted moving average is 10.91.
The unweighted moving average is preferred because it has a larger MSE compared to the weighted moving average.The unweighted moving average is preferred because it has a smaller MSE compared to the weighted moving average.    The weighted moving average is preferred because it has a larger MSE compared to the unweighted moving average.The weighted moving average is preferred because it has a smaller MSE compared to the unweighted moving average.
(c)
Suppose you are allowed to choose any weights as long as they sum to 1. Could you always find a set of weights that would make the MSE at least as small for a weighted moving average than for an unweighted moving average? Why or why not?
No, an unweighted moving average always has a smaller MSE than a weighted moving average.Yes, because an unweighted moving average is just a weighted moving average where the weights are equal.    No, sometimes you need to let the weights sum to a number higher/lower than 1 in order to get a smaller MSE than the one for an unweighted moving average.Yes, a weighted moving average always has a smaller MSE than an unweighted moving average.
 
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Similar questions
Recommended textbooks for you
MATLAB: An Introduction with Applications
MATLAB: An Introduction with Applications
Statistics
ISBN:
9781119256830
Author:
Amos Gilat
Publisher:
John Wiley & Sons Inc
Probability and Statistics for Engineering and th…
Probability and Statistics for Engineering and th…
Statistics
ISBN:
9781305251809
Author:
Jay L. Devore
Publisher:
Cengage Learning
Statistics for The Behavioral Sciences (MindTap C…
Statistics for The Behavioral Sciences (MindTap C…
Statistics
ISBN:
9781305504912
Author:
Frederick J Gravetter, Larry B. Wallnau
Publisher:
Cengage Learning
Elementary Statistics: Picturing the World (7th E…
Elementary Statistics: Picturing the World (7th E…
Statistics
ISBN:
9780134683416
Author:
Ron Larson, Betsy Farber
Publisher:
PEARSON
The Basic Practice of Statistics
The Basic Practice of Statistics
Statistics
ISBN:
9781319042578
Author:
David S. Moore, William I. Notz, Michael A. Fligner
Publisher:
W. H. Freeman
Introduction to the Practice of Statistics
Introduction to the Practice of Statistics
Statistics
ISBN:
9781319013387
Author:
David S. Moore, George P. McCabe, Bruce A. Craig
Publisher:
W. H. Freeman