Answered step by step
Verified Expert Solution
Question
1 Approved Answer
X Lease data Lease Cost 1/Sq Feet Parking/Sq Ft ($ per Sq Ft) $3,263 0.0050009 0.0300054 $2,908 0.0053116 0.0212464 $28, 159 0.0006497 0.0188413 $8,929 0.0019094
X Lease data Lease Cost 1/Sq Feet Parking/Sq Ft ($ per Sq Ft) $3,263 0.0050009 0.0300054 $2,908 0.0053116 0.0212464 $28, 159 0.0006497 0.0188413 $8,929 0.0019094 0.0229128 $3,501 0.0042877 0.0257262 $7,673 0.0018838 0.0131866 $7,749 0.0019452 0.0252876 $11,479 0.0016121 0.0209573 $387 0.0595516 $514 0.0403073 $1,905 0.0097621 0.0390484 $19,085 0.0008135 0.0219645 $4,437 0.0033657 0.0437541 $674 0.0272963 $888 0.0170784 $451 0.0349534 $929 0.0166451 $16,009 0.0009814 0.0196280 $1,503 0.0133115 0.0133115 $4,912 0.0031291 0.031291The accompanying data table gives annual costs of 20 commercial leases. The cost of the lease is measured in dollars per square foot, per year. Parking counts the number of parking spots in an adjacent garage that the realtor will build into the cost of the lease. The slope of 1/Sq Ft captures the fixed costs of the lease, those present regardless of the number of square feet. Fit the multiple regression of Cost per Sq Ft on 1/Sq Ft and Parking/Sq Ft, then complete parts (a) through (e) below. Click the icon to view the table of lease data. Use technology to find the multiple regression model. Assume that x, corresponds to 1/Sq Ft and x2 corresponds to Parking/Sq Ft. y = ( 0) + ( 0) * + () *2 Round to two decimal places as needed.) (a) Thinking marginally for a moment, should there be a correlation between the number of parking spots and the fixed cost of a lease? O A. No, because the parking spots are not being leased. O B. No, because the number of parking spots does not determine the fixed cost of a lease. O C. Yes, because the number of parking spots will attract more buyers for that lease. O D. Yes, because the number of parking spots increases the cost of maintaining the property. (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. Choose the correct answer below. O A. The coefficient of Parking/Sq Ft represents the number of square feet in the leased property per parking spot available for that property. O B. The coefficient of Parking/Sq Ft represents the number of parking spots available for a lease per square foot of the property leased. O C. The coefficient of Parking/Sq Ft represents the increase in cost of the lease per one parking spot increase in available parking spots. O D. The coefficient of Parking/Sq Ft represents the increase in parking spots available per one dollar increase in the cost of the lease. (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. Find the VIF between 1/Sq Ft and Parking/Sq Ft. VIF =(Round to three decimal places as needed.)(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. Find the VIF between 1/Sq Ft and Parking/Sq Ft. VIF = (Round to three decimal places as needed.) Had the two explanatory variables been uncorrelated, would the variation have been more clearly statistically significant? A. The t-statistic for the slope of Parking/Sq Ft would have been smaller by a factor of
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started