Home Sweet Home: Using Linear Regression to Analyze and Predict Home Prices

ByadminQuest

Chapter Project

Home Sweet Home: Using Linear Regression to Analyze and Predict Home Prices

An important problem in real estate is determining how to price homes to be sold. There are so many factors—size, age, and style of the home; number of bedrooms and bathrooms; size of the lot; and so on—which makes setting a price a challenging task. In this project, we will investigate the relationships among typical characteristics of homes and home prices, identify key variables related to pricing, and build linear regression models to predict prices based on property characteristics. Our analysis will be based on the Mount Pleasant Real Estate Data  Data

(available on stat.hawkeslearning.com). This data
set includes information about 245 properties for sale in three communities
in the suburban town of Mount Pleasant, South Carolina, in 2017.

The data can be found at stat.hawkeslearning.com Data Sets > Mount Pleasant Real Estate Data.

Phase 1: Data Preparation.

1.       Download the Mount Pleasant Real Estate Data from stat.hawkeslearning.com and open it with Microsoft Excel.

2.       To ensure the data contains comparable properties, eliminate duplexes and properties whose prices are outliers. What limitations does this impose on our analysis?

3.       The statistical tools from the current chapter focus on numeric data, so eliminate nonnumeric variables from the data. Does this remove potentially useful information?

4.      

Are there any redundant variables we could eliminate?

Phase 2: Discovering Relationships

5.      

How strongly does each remaining variable correlate to the price?

6.       Which variable correlates most strongly with price?

7.       Are any variables weakly correlated with price? Practically speaking, why do you think this is true?

8.       Do scatter plots reveal any nonlinear pattern between price and the weakly correlated variables?

      a.

$0$200,000$400,000$600,000$800,000$1,000,000$1,200,000

     b.

$0$200,000$400,000$600,000$800,000$1,000,000$1,200,000

Phase 3: Constructing Predictive Models.

Enable the Analysis ToolPak add-in to Excel.  The regression tool will be used.

9.      

Find the regression line ŷ = b0 + b1x predicting home price by the variable most highly correlated to it. Assess the fit of the line in terms of error and the proportion of variation explained by the model.

10.    

For which properties do the model’s predictions have the greatest errors? What is an intuitive reason for this?

Square Footage Line Fit Plot

0 1000 2000 3000 4000 5000 6000

Similar Posts

Read the following case study from your textbook: Case 15: The Diethylstilbestrol Story: An Investigation into the Evolving Public Health Policy for Pharmaceutical Products Then, visit the Kaiser Family Foundation Web site

ByadminQuest

National Health Policy versus State Policy Implementation National health policy sets the tone for the nation on how to implement, strategize, and achieve specific health goals. However, states often times have the option to not fully implement certain health policies based on their state needs. Thus, health policy varies in every state and can lead…

Critically discuss the challenges of the devolution of HRM to line managers and the role of leadership in the devolution. In doing so, you need to: Provide a broad review of the devolution of HRM to line managers.

ByadminQuest

Assessment Detail:- Number of Words: 2000 Subject: Business and HR Strategies Learning Outcomes After completing this assessment, the students should be able to: Critically evaluate theoretical constructs of Business and HR Strategy, including their relationship. Critically analyse a range of concepts, such as change management and the ways in which these can be horizontally and vertically integrated. Assessment Guidelines…

MC7080QA : Digital Marketing & Social Media Individual Report

ByadminQuest

Module Code: MC7080QA Module title: Digital Marketing & Social Media Assignment: Individual Written Report (1500 words) The individual written report requires students to provide a digital marketing plan containing a justified digital marketing and social media campaign for the brand addressed in assessment 1. Students should refer to and link their findings of the current…

In this project, you will demonstrate your mastery of the following competencies:Apply tools and techniques for reporting financial statement valuation and projectionsDetermine organizational health using economic, industry

ByadminQuest

SNHU ACC 345 project week 7 Project Guidelines and Rubric Project Guidelines and Rubric Competencies In this project, you will demonstrate your mastery of the following competencies:Apply tools and techniques for reporting financial statement valuation and projectionsDetermine organizational health using economic, industry, and financial analysesCommunicate business analyses and valuation reports to inform business decisionsOverviewAccounting professionals…

Assignment- You are currently working as a case manager at Youth Counseling Village. Taylor (they/them) is a senior in high school; you have been working with them for the past five months. Taylor was referred

ByadminQuest

Case Study #4: Taylor  You are currently working as a case manager atYouthCounselingVillage. Taylor (they/them) is a senior in high school; you have been working with them for the past five months. Taylor was referred to the Youth Counseling Village by their school guidance counselor after they disclosed that they were using drugs with classmates….