Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Table 1: Data Dictionary Variable name Definition age age of house agesq age^2 area square footage of house baths # bathrooms intst distance to
Table 1: Data Dictionary Variable name Definition age age of house agesq age^2 area square footage of house baths # bathrooms intst distance to interstate, ft. land nearinc post rooms rprice square footage lot =1 if dist = 3 miles =1 if post period; =0 if pre period # rooms in house price, real dollars Table 2: Bivariate Regression Model Summary Adjusted R Std. Error of Model R R Square Square the Estimate 1 .241a .058 .055 32194.24307 a. Predictors: (Constant), =1 if post period ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 20359557328. 1 20359557328. 19.643 .000b 212 212 Residual 33063370248 319 1036469286.7 8.208 97 Total 35099325981 320 6.420 a. Dependent Variable: price, real dollars b. Predictors: (Constant), =1 if post period Coefficientsa Standardized Unstandardized Coefficients Coefficients Model B Std. Error Beta t Sig. 1 (Constant) 76628.039 2406.311 31.845 .000 post 16034.890 3617.929 .241 4.432 .000 a. Dependent Variable: price, real dollars Table 3: Multiple Regression Model Summary R Model R Square .807a .651 Adjusted R Square Std. Error of the Estimate .641 19841.12911 1 a. Predictors: (Constant), # rooms in house, 1 if post period, age of house, square footage lot, =1 if dist < 3 miles, square footage of house, dist. to interstate, ft., # bathrooms, age^2 ANOVAa Model Sum of Squares df Mean Square F Sig. 1 Regression 22856176404 9 25395751560. 64.510 .000b 6.733 748 Residual 12243149576 311 393670404.40 9.687 4 Total 35099325981 320 6.420 a. Dependent Variable: price, real dollars b. Predictors: (Constant), # rooms in house, =1 if post period, age of house, square footage lot, =1 if dist
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