Instructions: Submit a well-formatted Word, pdf, or similar file in Canvas with your R scripts, regression output, and answers to the questions below. This lab exercise asks you to evaluate the housing market. The data set housingprices40.csv contains all sales of single-family homes in Davis, CA in May 2018 (n = 40). Assume that these homes are a random sample. The dependent variable in the regression model is the natural logarithm of the actual price of each house sold. The regression specification is: In(price;) = B2 + B2 In(estimate;) + B3bdrms; + B4bathrms; +B; In(sqrft;) + B6 In(lotsize}) + Brage; + Bapooli+Bocentrali + & where price is the house selling price, estimate is the estimated housing value from April 2018 from a prominent online site that values homes, bdrms is the number of bedrooms, bathrms is the number of bathrooms, sqrft is the interior square footage, lotsize is size of the lot (in feet), age is the age of the house in years, pool is a binary variable set to 1 if the house has a pool, and central is a binary variable if the house is in central Davis, near downtown. Note “In” stands for the natural logarithm, and you can take the natural logs of variables in R with the command log(). For example, to compute the natural log of sales prices, use: Inprice = log (price) Note that this question is very similar to the example from lecture on testing multiple coefficients. Suppose we would like to test whether the estimated online housing price is a rational valuation of the true housing price. If this is the case, then a 1% change in estimate should be associated with a 1% change in price. In addition, none of the other explanatory variables should help explain In(price) once the estimated value has been controlled for. That is, the online estimate should take the values of all these other explanatory variables into account (and many others that have not been included in the unrestricted multiple regression model when estimating the value of a house). There are eight restrictions to be tested under Ho: Ho: B2 = 1, B3 = 0, B4 = 0,35 = 0,36 = 0,37 = 0,38 = 0, and B, = 0 1. Estimate the unrestricted model using OLS with R. Name this regression model olsu in R. Report your results using the package stargazer to create professional looking regression output tables.
Instructions: Submit a well-formatted Word, pdf, or similar file in Canvas with your R scripts, regression output, and answers to the questions below. This lab exercise asks you to evaluate the housing market. The data set housingprices40.csv contains all sales of single-family homes in Davis, CA in May 2018 (n = 40). Assume that these homes are a random sample. The dependent variable in the regression model is the natural logarithm of the actual price of each house sold. The regression specification is: In(price;) = B2 + B2 In(estimate;) + B3bdrms; + B4bathrms; +B; In(sqrft;) + B6 In(lotsize}) + Brage; + Bapooli+Bocentrali + & where price is the house selling price, estimate is the estimated housing value from April 2018 from a prominent online site that values homes, bdrms is the number of bedrooms, bathrms is the number of bathrooms, sqrft is the interior square footage, lotsize is size of the lot (in feet), age is the age of the house in years, pool is a binary variable set to 1 if the house has a pool, and central is a binary variable if the house is in central Davis, near downtown. Note “In” stands for the natural logarithm, and you can take the natural logs of variables in R with the command log(). For example, to compute the natural log of sales prices, use: Inprice = log (price) Note that this question is very similar to the example from lecture on testing multiple coefficients. Suppose we would like to test whether the estimated online housing price is a rational valuation of the true housing price. If this is the case, then a 1% change in estimate should be associated with a 1% change in price. In addition, none of the other explanatory variables should help explain In(price) once the estimated value has been controlled for. That is, the online estimate should take the values of all these other explanatory variables into account (and many others that have not been included in the unrestricted multiple regression model when estimating the value of a house). There are eight restrictions to be tested under Ho: Ho: B2 = 1, B3 = 0, B4 = 0,35 = 0,36 = 0,37 = 0,38 = 0, and B, = 0 1. Estimate the unrestricted model using OLS with R. Name this regression model olsu in R. Report your results using the package stargazer to create professional looking regression output tables.
Step by step
Solved in 3 steps
