1. Business
  2. Economics
  3. the quarterly sales data number of copies sold for a...

Question: the quarterly sales data number of copies sold for a...

Question details

The quarterly sales data (number of copies sold) for a college textbook over the past three years follow:

Year Quarter Sales
1 1 1690
2 940
3 2625
4 2500
2 1 1800
2 900
3 2900
4 2360
3 1 1850
2 1100

3

4

2930

2615

a. Construct a time series plot. What type of pattern exists in the data?   (4 marks)

b. Show the four‐quarter and centered moving average values for this time series. (5 marks)

c. Compute the seasonal and adjusted seasonal indexes for the four quarters. (5 marks)

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

e. Deseasonalize the time series. (4 marks)

f. Compute the linear trend equation for the deseasonalized data and forecast sales, using the linear trend equation. (8 marks)

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

Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution