Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Linear Algebra and Its Applications

Authors: David C. Lay

4th edition

321791541, 978-0321388834, 978-0321791542

More Books

Students also viewed these Mathematics questions

Question

Use translations to graph f. f(x) = x-/2 +1

Answered: 1 week ago