# Question

This exercise considers monthly prices of shares in JC Penney from January 2000 through the end of 2011.9 The data table includes a column Month with values 1, 2 , ., 120 that can be used as the time index t.

(a) Fit a polynomial trend model to the time series of prices. Try polynomials of various degrees (i.e., try polynomials with t, t2, and other powers up to t6). Do any of these, with orders of 6 or less, capture the ups and downs of the prices?

(b) Compare the ability of a polynomial trend to follow the pattern in this time series to that of two exponentially weighted moving averages (with w = 0.5 and w = 0.9).

(c) Fit an auto regression to the time series of prices, using three lags of the price (yt -1, yt -2, and yt -3). Are all of these lagged predictors useful? Remove predictors that do not significantly improve the fit of the model and summarize your final model. (There’s a lot of collinearity among these predictors, so remove predictors one at a time.)

(d) Does the model you created in part (c) meet the conditions for the MRM?

(e) The data table includes the returns on Sears stock during this period. [Returns are the ratio of the change in price to the price in the earlier period, (price t – price t -1) / price t -1.] Does the sequence of returns appear simple, or do you find a pattern that can be used to forecast future returns?

(f) Compare using the model in part (c) for forecasting the price of this stock in the next month to a method that uses the simplicity of the returns. Which would you prefer to use (if either)? Explain your choice.

(a) Fit a polynomial trend model to the time series of prices. Try polynomials of various degrees (i.e., try polynomials with t, t2, and other powers up to t6). Do any of these, with orders of 6 or less, capture the ups and downs of the prices?

(b) Compare the ability of a polynomial trend to follow the pattern in this time series to that of two exponentially weighted moving averages (with w = 0.5 and w = 0.9).

(c) Fit an auto regression to the time series of prices, using three lags of the price (yt -1, yt -2, and yt -3). Are all of these lagged predictors useful? Remove predictors that do not significantly improve the fit of the model and summarize your final model. (There’s a lot of collinearity among these predictors, so remove predictors one at a time.)

(d) Does the model you created in part (c) meet the conditions for the MRM?

(e) The data table includes the returns on Sears stock during this period. [Returns are the ratio of the change in price to the price in the earlier period, (price t – price t -1) / price t -1.] Does the sequence of returns appear simple, or do you find a pattern that can be used to forecast future returns?

(f) Compare using the model in part (c) for forecasting the price of this stock in the next month to a method that uses the simplicity of the returns. Which would you prefer to use (if either)? Explain your choice.

## Answer to relevant Questions

1. A column in a data table holds the values associated with an observation. 2. A Likert scale represents numerical data. 3. Recoding adds further columns to a data table. 4. Aggregation adds further rows to a data table. 5. ...A major bank collected data on 100,000 of its customers (income, sex, location, number of cards, etc.) and then computed how much profit it made from the account of these customers during 2010. (a) Identity whether the data ...Concern over an aging product line led the Wall Street Journal to publish a chart with a cover-page article on future profits of drug-maker Pfzer.7 Is it a bar chart in the sense of this chapter or a timeplot that uses bars? Random variation often looks like a trend. The response in this exercise has n = 120 observations, as if 12 years of monthly data. The values of the response were simulated using random numbers so that Yt = Yt -1 + et with ...Advertising A local financial advisor places advertisements in the local newspaper as well as on local cable television programs. Her success depends on how many callbacks these ads generate. She wants to know if the ...Post your question

0