The following data, stored in CoreAppliances provide the total number of shipments of core major household appliances
Question:
The following data, stored in CoreAppliances provide the total number of shipments of core major household appliances in the U.S. from 2000 to 2014 (in millions).
a. Plot the time series.
b. Fit a three-year moving average to the data and plot the results.
c. Using a smoothing coefficient of W = 0.50, exponentially smooth the series and plot the results.
d. What is your exponentially smoothed forecast for 2015?
e. Repeat (c) and (d), using W = 0.25.
f. Compare the results of (d) and (e).
g. What conclusions can you reach concerning the total number of shipments of core major household appliances in the U.S. from 2000 to 2014 (in millions)?
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Statistics For Managers Using Microsoft Excel
ISBN: 9780134173054
8th Edition
Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat
Question Posted: