What is the estimated increase in price for a house

Reference no: EM133726366

Assignment: Housing Price Analysis Problem Set

Question is an empirical exercise. Along with the problem set, we posted a file named hprice.xls. Using data included in this file, you are expected to conduct analyses. For this problem, you need to submit: (1) output from the analyses; (2) your codes; and (3) arguments/explanations when asked for. You can use R, python, stata etc. However, the solutions we provide will be based on R. Empirical exercise, to be solved using R (or Stata, Python, etc). In this exercise you will investigate the relationship between housing prices and the physical characteristics of a home. On the course website you will find a data file hprice.xls (in Excel format), collected from the real estate pages of the Boston Globe in 1990 (these are homes selling in the Boston, MA area). It contains data on the selling price (price) of the house (in $1000), the size (sqrft) of the house in square feet, the number of bedrooms (bdrms), the size of the lot (lotsize) in square feet, and a dummy variable (colonial) which is equal to 1 if the home was colonial style. Use these data to answer the following questions. In all your regressions, please include an intercept term (i.e. ?0). Make sure to include your output and code with your homework!

1. Run a regression of selling price (price) on the size of the home (sqrft) and the number of bedrooms (bdrms) and report your results.

2. What is the estimated increase in price for a house with one more bedroom, holding square footage constant?

3. What is the estimated increase in price for a house with an additional bedroom that is 140 square feet in size? Compare this to your result in part 2).

4. What percentage of the variation in price is explained by square footage and the number of bedrooms?

5. The first house in the sample has sqrft = 2,438 and bdrms = 4. Find the predicted selling price for this house from the OLS regression line.

6. The actual selling price of the first house in the sample was $300,000 (so price = 300). Find the residual for this house. Does it suggest that the buyer underpaid or overpaid for the house?

7. Suppose that instead of the regression described in part a), you ran a regression of price on sqrft (i.e. you left out bedrooms). Would you expect this regression to suffer from an omitted variables problem? If so, in what direction would you expect the coefficient on sqrft to be biased? Now run this regression and see if you were right.

8. Now, suppose you included lotsize in the original regression. Will you have a problem with perfect multicollinearity? Why or why not? Run this regression (if you can) and interpret the coefficient on lotsize.

Reference no: EM133726366

Questions Cloud

EBP projects to improve patient care-safety : Discuss how you will use information from others and your own EBP projects to improve patient care/safety.

Obtain the physical exam needed for your externship : You have gone to the doctor to obtain the physical exam needed for your externship.

Patient comes into office with complaint of sore throat : A patient comes into the office with the complaint of a sore throat, fatigue, and mild fever.

Preparing injection of lantus insulin for diabetic : You are preparing an injection of Lantus insulin for a diabetic patient and you note that it appears cloudy. What action should you prepare to take?

What is the estimated increase in price for a house : What is the estimated increase in price for a house with an additional bedroom that is 140 square feet in size? Compare this to your result in part 2).

You work orders incontinent pads in bulk : The nursing unit where you work orders incontinent pads in bulk. If the latest order is for 25 packages, and each package contains 35 pads,

How could you use the framework to reduce per capita cost : NSG 476 University of Phoenix- How could you use the framework to reduce the per capita cost of healthcare in your own work environment to better align the need

Budget for a criminal justice agency you work for : What extent should a criminal justice agency or department allow social influence or pressure to influence budgetary policies or strategies?

What are three things you could have done to improve : Describe the worst Team Project you have participated in as a class assignment. What are three things you could have done to improve that team experience?

User Account

All Pages