[Solution Library] The following table shows the quarterly sales of an auto parts manufacturer: Year Quarter Sales (Millions) 2000 1 $1170 2 1615 3 1585 4 1520
Question: The following table shows the quarterly sales of an auto parts manufacturer:
| Year | Quarter | Sales (Millions) | |
| 2000 | 1 | $1170 | |
| 2 | 1615 | ||
| 3 | 1585 | ||
| 4 | 1520 | ||
| 2001 | 1 | 1230 | |
| 2 | 1505 | ||
| 3 | 1610 | ||
| 4 | 1615 | ||
| 2001 | 1 | 1315 | |
| 2 | 1660 | ||
| 3 | 1645 | ||
| 4 | 1620 | ||
- Calculate the centered moving average of this series, using one year of data at a time.
- Construct a time series plot for both the raw data and the moving average.
- Which is the firm's worst quarter?
- Find the seasonally adjusted sales corresponding to each of the original sales values.
Price: $2.99
Solution: The downloadable solution consists of 2 pages
Deliverable: Word Document 