The following data (stored in Coffee Price Portugal represent the retail price of coffee (in/kg) in Portugal

Question:

The following data (stored in Coffee Price Portugal represent the retail price of coffee (in‚¬/kg) in Portugal from 2004 to 2011:
The following data (stored in Coffee Price Portugal represent the

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 2012?
e. Repeat (c) and (d), using W = 0.25.
f. Compare the results of (d) and (e).

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: 9780133130805

7th Edition

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

Question Posted: