Use exploratory data analysis to determine whether there is a trend and/or seasonality in mobile home shipments
Question:
Use exploratory data analysis to determine whether there is a trend and/or seasonality in mobile home shipments (MHS). The data by quarter are shown in the following table.
Period | MHS | Period | MHS | Period | MHS | Period | MHS | |||
Mar-81 | 54.9 | Dec-84 | 66.2 | Sep-88 | 59.2 | Jun-92 | 52.8 | |||
Jun-81 | 70.1 | Mar-85 | 62.3 | Dec-88 | 51.6 | Sep-92 | 57 | |||
Sep-81 | 65.8 | Jun-85 | 79.3 | Mar-89 | 48.1 | Dec-92 | 57.6 | |||
Dec-81 | 50.2 | Sep-85 | 76.5 | Jun-89 | 55.1 | Mar-93 | 56.4 | |||
Mar-82 | 53.3 | Dec-85 | 65.5 | Sep-89 | 50.3 | Jun-93 | 64.3 | |||
Jun-82 | 67.9 | Mar-86 | 58.1 | Dec-89 | 44.5 | Sep-93 | 67.1 | |||
Sep-82 | 63.1 | Jun-86 | 66.8 | Mar-90 | 43.3 | Dec-93 | 66.4 | |||
Dec-82 | 55.3 | Sep-86 | 63.4 | Jun-90 | 51.7 | Mar-94 | 69.1 | |||
Mar-83 | 63.3 | Dec-86 | 56.1 | Sep-90 | 50.5 | Jun-94 | 78.7 | |||
Jun-83 | 81.5 | Mar-87 | 51.9 | Dec-90 | 42.6 | Sep-94 | 78.7 | |||
Sep-83 | 81.7 | Jun-87 | 62.8 | Mar-91 | 35.4 | Dec-94 | 77.5 | |||
Dec-83 | 69.2 | Sep-87 | 64.7 | Jun-91 | 47.4 | Mar-95 | 79.2 | |||
Mar-84 | 67.8 | Dec-87 | 53.5 | Sep-91 | 47.2 | Jun-95 | 86.8 | |||
Jun-84 | 82.7 | Mar-88 | 47 | Dec-91 | 40.9 | Sep-95 | 87.6 | |||
Sep-84 | 79 | Jun-88 | 60.5 | Mar-92 | 43 | Dec-95 | 86.4 |
1. On the basis of your analysis, do you think there is a significant trend in MHS? Is there seasonality?
2. What forecasting methods might be appropriate for MHS according to the guidelines in Table 2.1?
Step by Step Answer:
Forecasting And Predictive Analytics With Forecast X
ISBN: 978-1259903915
7th edition
Authors: J. Holton Wilson, Barry Keating