Chad Dobson has heard about the positive outlook for real estate investment in college towns. He is interested in investing in Davis, California, which houses one of the University of California...

1 answer below »



Chad Dobson has heard about the positive outlook for real estate investment in college towns. He is interested in investing in Davis, California, which houses one of the University of California campuses. He uses zillow.com to access data on 2011 monthly rent for 27 houses, along with three characteristics of the home: number of bedrooms (Beds), number of bathrooms (Baths), and square footage (Sqft). A portion of the data is shown in the accompanying table; the complete data, labeled Davis Rental, are available on the text website.

a.       Estimate a linear model that uses rent and an exponential model that uses log of rent as the response variable.


b.       Compute the predicted rent for a 1,500-square-foot house with three bedrooms and two bathrooms for the linear and the exponential model (lgnore the significance tests).


c.       Use R2
to select the appropriate model for prediction.




Answered Same DayDec 25, 2021

Answer To: Chad Dobson has heard about the positive outlook for real estate investment in college towns. He is...

David answered on Dec 25 2021
119 Votes
Solution using Excel
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.890831
R Square 0.79358

Adjusted R
Square 0.766656
Standard
Error 284.6173
Observatio
ns 27
ANOVA
df SS MS F
Significan
ce F
Regression 3
716292
8
238764
3
29.474
52 4.68E-08
Residual 23
186316
1 81007
Total 26
902608
9
Coefficie
nts
Standar
d Error t Stat P-value
Lower
95%
Upper
95%
Lower
95.0%
Upper
95.0%
Intercept 65.82551
267.26
04
0.2462
97
0.8076
37 -487.045
618.69
58
-
487.04
5
618.69
58
Beds 237.8506
194.86
22
1.2206
09
0.2346
01 -165.253...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here