expand icon
book Business Forecasting 6th Edition by Holton Wilson, Barry Keating, John Solutions cover

Business Forecasting 6th Edition by Holton Wilson, Barry Keating, John Solutions

Edition 6ISBN: 978-0077309305
book Business Forecasting 6th Edition by Holton Wilson, Barry Keating, John Solutions cover

Business Forecasting 6th Edition by Holton Wilson, Barry Keating, John Solutions

Edition 6ISBN: 978-0077309305
Exercise 3
Using data for 1985Q1 through 2007Q1, calculate the autocorrelation coefficients for The Gap's quarterly sales (the quarterly data are in Table 1.6 and in the C2Gap.xls data file) using twelve lags, and construct the corresponding correlogram (plot of the autocorrelations) for lags of 1 through 12. What do the autocorrelation coefficients and the correlogram tell you about the series?
Table 1.6
Using data for 1985Q1 through 2007Q1, calculate the autocorrelation coefficients for The Gap's quarterly sales (the quarterly data are in Table 1.6 and in the C2Gap.xls data file) using twelve lags, and construct the corresponding correlogram (plot of the autocorrelations) for lags of 1 through 12. What do the autocorrelation coefficients and the correlogram tell you about the series? Table 1.6         TABLE 1.6 The Gap Sales and a Modified Naïve Forecast (Forecast _ Sales[ _ 4]) (c1t6 f10) The Gap sales data are in thousands of dollars by quarter. The months indicated in the date columns represent the middle month in The Gap's financial quarter. For example, the first quarter in its fiscal year includes February, March, and April.
Using data for 1985Q1 through 2007Q1, calculate the autocorrelation coefficients for The Gap's quarterly sales (the quarterly data are in Table 1.6 and in the C2Gap.xls data file) using twelve lags, and construct the corresponding correlogram (plot of the autocorrelations) for lags of 1 through 12. What do the autocorrelation coefficients and the correlogram tell you about the series? Table 1.6         TABLE 1.6 The Gap Sales and a Modified Naïve Forecast (Forecast _ Sales[ _ 4]) (c1t6 f10) The Gap sales data are in thousands of dollars by quarter. The months indicated in the date columns represent the middle month in The Gap's financial quarter. For example, the first quarter in its fiscal year includes February, March, and April.
TABLE 1.6 The Gap Sales and a Modified Naïve Forecast (Forecast _ Sales[ _ 4]) (c1t6 f10) The Gap sales data are in thousands of dollars by quarter. The months indicated in the date columns represent the middle month in The
Gap's financial quarter. For example, the first quarter in its fiscal year includes February, March, and April.
Explanation
Verified
like image
like image

As you see from the autocorrel...

close menu
Business Forecasting 6th Edition by Holton Wilson, Barry Keating, John Solutions
cross icon