Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Use the data in the file HW4 House price, n=90.xlsx. The file contains data on the variables Price, Lot size, Square footage, and house design
Use the data in the file "HW4 House price, n=90.xlsx." The file contains data on the variables Price, Lot size, Square footage, and house design (whether colonial or not). 1. Estimate the following model in Gretl and paste the regression output below. Price = 1*LotSize 2*Sqrft 3*Colonial Paste Regression Output here: Model 1: OLS, using observations 1-90 Dependent variable: price Coefficient Std. Error t-ratio p-value const 4586.64 24648.2 0.1861 0.8528 lotsize 2.10734 0.640752 3.289 0.0015 *** sqrft 132.020 11.2926 11.69 <0.0001 *** colonial 19229.1 13792.6 1.394 0.1669 Mean dependent var 294467.2 S.D. dependent var 101873.7 Sum squared resid 3.08e 11 S.E. of regression 59806.81 R-squared 0.666969 Adjusted R-squared 0.655351 F(3, 86) 57.41128 P-value(F) 1.80e-20 Log-likelihood 1115.557 Akaike criterion 2239.115 Schwarz criterion 2249.114 Hannan-Quinn 2243.147 a) Write out the equation for the estimated model
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