# Question: This data table gives annual costs of 223 commercial leases

This data table gives annual costs of 223 commercial leases. All of these leases provide office space in a Midwestern city in the United States. The cost of the lease is measured in dollars per square foot, per year. The number of square feet is as labeled, and Parking counts the number of parking spots in an adjacent garage that the realtor will build into the cost of the lease. Fit the multiple regression of Cost per Sq Ft on 1 / Sq Ft and Parking / Sq Ft. (Recall that the slope of 1 / Sq Ft captures the fixed costs of the lease, those present regardless of the number of square feet.)

(a) Thinking marginally for a moment, should there be a correlation between the number of parking spots and the fixed cost of a lease?

(b) Interpret the coefficient of Parking / Sq Ft. Once you figure out the units of the slope, you should be able to get the interpretation.

(c) One of the two explanatory variables explains slightly more than statistically significant variation in the price. Had the two explanatory variables been uncorrelated (and produced these estimates), would the variation have been more clearly statistically significant? Use the VIF to see.

(d) We can see the effects of collinearity by constructing a plot that shows the slope of the multiple regression. To do this, we have to remove the effect of one of the explanatory variables from the other variables. Here’s how to make a so-called partial regression leverage plot for these data. First, regress Cost / Sq Fit on Parking / Sq Fit and save the residuals. Second, regress 1/ Sq Fit on Parking / Sq Fit and save these residuals. Now, make a scatterplot of the residuals from the regression of Cost / Sq Ft on Parking / Sq Fit on the residuals from the regression of 1 / Sq Fit on Parking>Sq Ft. Fit the simple regression for this scatterplot, and compare the slope in this fit to the partial slope for 1 / Sq Ft in the multiple regression. Are they different?

(e) Compare the scatterplot of Cost / Sq Ft on 1 / Sq Ft to the partial regression plot constructed in part (d). What has changed?

(a) Thinking marginally for a moment, should there be a correlation between the number of parking spots and the fixed cost of a lease?

(b) Interpret the coefficient of Parking / Sq Ft. Once you figure out the units of the slope, you should be able to get the interpretation.

(c) One of the two explanatory variables explains slightly more than statistically significant variation in the price. Had the two explanatory variables been uncorrelated (and produced these estimates), would the variation have been more clearly statistically significant? Use the VIF to see.

(d) We can see the effects of collinearity by constructing a plot that shows the slope of the multiple regression. To do this, we have to remove the effect of one of the explanatory variables from the other variables. Here’s how to make a so-called partial regression leverage plot for these data. First, regress Cost / Sq Fit on Parking / Sq Fit and save the residuals. Second, regress 1/ Sq Fit on Parking / Sq Fit and save these residuals. Now, make a scatterplot of the residuals from the regression of Cost / Sq Ft on Parking / Sq Fit on the residuals from the regression of 1 / Sq Fit on Parking>Sq Ft. Fit the simple regression for this scatterplot, and compare the slope in this fit to the partial slope for 1 / Sq Ft in the multiple regression. Are they different?

(e) Compare the scatterplot of Cost / Sq Ft on 1 / Sq Ft to the partial regression plot constructed in part (d). What has changed?

**View Solution:**## Answer to relevant Questions

This data table contains accounting and financial data that describe 324 companies operating in the information sector in 2010. The largest of these provide telephone services. The variables include the expenses on research ...These data track monthly performance of stock in Apple Computer since 1990. The data include 264 monthly returns on Apple Computer, as well as returns on the entire stock market, the S&P 500 index, stock in IBM, and Treasury ...When fitting the regression of Y on X for two groups, we can estimate the slope and intercept within each group either by fitting two simple regressions or by fitting one multiple regression. If simple regressions are so ...The following output summarizes the fit of an analysis of covariance to the data in Exercise 35. The variable D denotes a dummy variable, with D = + for values colored green and 0 otherwise. (a) Does the fit of the model ...Cars (introduced in Chapter 19) The cases that make up this dataset are types of cars. For each of 318 types of cars sold in the United States during the 2011 model year, we have the combined mileage and the horsepower of ...Post your question