The following data, stored in Core Appliances , list the number of shipments of core major household

Question:

The following data, stored in Core Appliances , list the number of shipments of core major household appliances in the United States from 2000 to 2017 (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 2018?
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 United States from 2000 to 2017 (in millions)?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 9780135969854

9th Edition

Authors: David M. Levine, David F. Stephan, Kathryn A. Szabat

Question Posted: