solution

The sales manager of a large automotive parts distributor, Hartman Auto Supplies, wants to develop a model to forecast as early as May the total annual sales of a region. If regional sales can be forecast, then the total sales for the company can be forecast. The number of retail outlets in the region stocking the company’s parts and the number of automobiles registered for each region as of May 1 are the two independent variables investigated. The data appear in Table P-12.

a. Analyze the correlation matrix.

b. How much error is involved in the prediction for region 1?

c. Forecast the annual sales for region 12, given 2,500 retail outlets and 20.2 million automobiles registered.

d. Discuss the accuracy of the forecast made in part c.

 e. Show how the standard error of the estimate was computed.

 f. Give an interpretation of the partial regression coefficients. Are these regression coefficients sensible?

g. How can this regression equation be improved?

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

solution

The scores for two within-term examinations, and; the current grade point average (GPA), and the final exam score, Y, for 20 students in a business statistics class are listed in Table P-18.

a. Fit a multiple regression model to predict the final exam score from the scores on the within-term exams and GPA. Is the regression significant? Explain.

b. Predict the final exam score for a student with within-term exam scores of 86 and 77 and a GPA of 3.4.

c. Compute the VIFs and examine the t statistics for checking the significance of the individual predictor variables. Is multicollinearity a problem? Explain.

d. Compute the mean leverage. Are any of the observations high leverage points?

 e. Compute the standardized residuals. Identify any observation with a large standardized residual. Does the fitted model under- or overpredict the response for these observations?

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

solution

Table P-21 contains the number of accounts (in thousands) and the assets (in billions of dollars) for 10 online stock brokerages. Plot the assets versus the number of accounts. Investigate the possibility the relationship is curved by running a multiple regression to forecast assets using the number of accounts and the square of the number of accounts as independent variables.

a. Give the fitted regression function. Is the regression significant? Explain.

b. Test for the significance of the coefficient of the squared term. Summarize your conclusion.

c. Rerun the analysis without the quadratic (squared) term. Explain why the coefficient of the number of accounts is not the same as the one you found for part a.

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

solution

The 1991 accounting numbers for major league baseball are given in Table P-24. All figures are in millions of dollars. The numerical variables are Greet (Gate Receipts), Mediate (Media Revenue), Starve (Stadium Revenue), Torte (Total Revenue), Player CT (Player Costs), EpiPens (Operating Expenses), Oncome and Frenal (Franchise Value).

a. Construct the correlation matrix for the variables Greet, Mediate, …, Frenal. From the correlation matrix, can you determine a variable that is likely to be a good predictor of Frenal? Discuss.

b. Use stepwise regression to build a model for predicting franchise value using the remaining variables. Are you surprised at the result? Explain.

c. Can we conclude that, as a general rule, franchise value is about twice total rev-enue? Discuss.

d. Player costs are likely to be a big component of operating expenses. Develop an equation for forecasting operating expenses from player costs. Comment on the strength of the relation. Using the residuals as a guide, identify teams that have unusually low or unusually high player costs as a component of operating expenses.

e. Consider the variables other than Frenal. Given their definitions, are there groups of variables that are multicollinear? If so, identify these sets.

 

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