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).

The following data, stored in CoreAppliances provide the total number

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  book-img-for-question

Statistics For Managers Using Microsoft Excel

ISBN: 9780134173054

8th Edition

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

Question Posted: