The following table shows us the quarterly sales data for a fiction book over the past three years:

Quarter  Year 1     Year 2     Year 3 

1                1690       1800        1850

2                  940          900        1100 

3                2625        2900        2930 

4                2500        2360        2615

a. Construct a time series plot. What type of pattern exists in the data?

b. Show the four-quarter and centered moving average values for this time series.

c. Compute the seasonal and adjusted seasonal indexes for the four quarters.

d. When does the publisher have the largest seasonal index? Does this result appear reasonable? Explain.

e. DE seasonalize the time series.

f. Compute the linear trend equation for the de-seasonalized data and forecast sales using the linear trend equation. 

g. Adjust the linear trend forecasts using the adjusted seasonal indexes computed in part (c).

Answer rating: 100% (QA)

a Construct a time series plot What type of pattern exists in the data The time series plot for the data is shown below Time Series Plot for Quarterly ... View the full answer