solution

Although the time series data in Table P-18 are old, they provide the basis for some interesting regression modelling. Using the data in Table P-18, attempt to relate personal savings to personal income (in billions of dollars) for the time period from 1935 to 1954.

a. Fit a simple linear regression model to the data in Table P-18, using personal income to predict personal savings. (1) Test for the significance of the regression at the level; (2) calculate, and interpret this quantity; and (3) test for autocorrelation using the Durbin-Watson test with. Should you modify your conclusion in part 1? How can the model be improved?

 b. Construct a dummy variable, for the WWII years. Let for peacetime and for wartime. The war years are from 1941 to 1945. Fit a multiple linear regression model using personal income and the war years dummy variable as predictor variables for personal savings. Evaluate the results. Specifically (1) test to determine whether knowledge of the war years makes a significant contribution to the prediction of personal savings beyond that provided by personal income (set) and (2) test for autocorrelation. Is the multiple regression model better than the simple linear regression model of part a? Discuss.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Thomas Furniture Company concludes that production scheduling can be improved by developing an accurate method of predicting quarterly sales. The company analyst, Mr. Estes, decides to investigate the relationship between housing construction permits and furniture sales in the Springfield area. Estes feels that permits will lead sales by one or two quarters. In addition, he wonders if furniture sales are seasonal. Estes decides to consider another independent variable:

The data are given in Table P-14.

a. Develop a regression model that uses housing construction permits as the predictor variable.

b. Test for autocorrelation in this model.

 c. Develop a regression model that uses both permits and the seasonal dummy as predictor variables.

d. Is there a significant seasonal pattern in these data? (Test at the .05 level.)

e. Is there an autocorrelation problem with the multiple regression model developed in part c? If so, how might it be corrected?

f. Using the model from part a, forecast Thomas Furniture Company sales for the four quarters of 2007. (Notice you will need some additional values for construction permits to develop forecasts for the four quarters of 2007.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Thompson Airlines has determined that 5% of the total number of U.S. domestic airline passengers fly on Thompson planes. You are given the task of forecasting the number of passengers who will fly on Thompson Airlines in 2007. The data are presented in Table P-13.

a. Develop a time series regression model, using time as the independent variable and the number of passengers as the dependent variable. Fit this model.

b. Is the assumption of independent errors for this model viable?

 c. Fit the model in part a with the logarithms of the number of passengers as the dependent variable.

 d. Repeat part a with the time represented by an exponential trend.

e. Which of the models in parts c and d do you prefer? Why?

 f. Do the errors for either of the models in parts c and d appear to be independent? If not, what problem(s) might arise when using one (or both) of these fitted models for forecasting?

g. Using your preferred model, forecast the number of Thompson Airlines passengers for 2007.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

The demand for a commodity typically depends on the income of the consumer, the real price of the commodity, and the real price of complementary or competing products. Table P-20 gives the per capita consumption of chicken in the United States (in pounds); the per capita disposable income (in dollars); and the retail prices for chicken, pork, and beef (in cents per pound) for several years.

 a. Compute the correlation matrix for all the variables, using both the original units and the log-transformed units. Comment on the implied strength of the linear association between chicken consumed and each of the remaining variables. Can you think of a reason why one must be careful interpreting the magnitudes of correlation coefficients constructed from time series data?

 b. Using the original data, run a stepwise regression program with chicken consumption as the dependent variable and the remaining variables as predictor variables. Set alpha to. enter = alpha to remove = .05.

c. Run a full regression of chicken consumption on the remaining variables. Be sure to delete variables one at a time that you deem to be not significant until you are satisfied with your final model. Is your result consistent with the result of the stepwise procedure in part b? Is serial correlation likely to be a problem in this regression analysis?

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"