The data below, stored in Computer Usage represent the hours per day spent by American desktop and

Question:

The data below, stored in Computer Usage represent the hours per day spent by American desktop and laptop users from 2008 to 2017.

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 about desktop/laptop use by American users?

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: