MAT 240 Project One

.docx

School

Southern New Hampshire University *

*We aren’t endorsed by this school

Course

MAT240

Subject

Economics

Date

Feb 20, 2024

Type

docx

Pages

9

Uploaded by MinisterSwanMaster994

Median Housing Price Prediction Model for D. M. Pan National Real Estate Company 1 Report: Housing Price Prediction Model for D. M. Pan National Real Estate Company Dianna Sheely Southern New Hampshire University
Median Housing Price Model for D. M. Pan National Real Estate Company 2 Introduction As D.M. Pan National Real Estate Company requested, this project aims to create a model to predict median housing prices for homes sold in 2019. This report aims to help D.M Pan National Real Estate Company associates better understand the correlation between the square footage and listing prices of homes and give them a tool to use to predict home prices more accurately based on square footage. Since we want to determine the strength of the square footage and listing prices, it is appropriate to use simple linear regression in this analysis. This report will contain charts and graphs to visualize the correlation between these variables, square footage, and housing prices, such as a scatterplot and a histogram. If our linear model is appropriate, the histogram should look normal, and the scatterplot of residuals should show random scatter. Our (x) variable will be “square feet” and (y) the “listing price” on our charts and graphs. We expect a straight line and a strong correlation between the two variables. We expect that as “square feet” increases that the “listing price” will also increase. Our scatterplot should show a positive slope unless we have strong outliers. Our analysis will also include lines and equations that will be useful, such as the regression line (or predicted line), which can be used to estimate (or forecast) the response variable. Our Predictor variable (x) is "square feet," and our Response variable (y) is "listing price.” Again, we expect that as the square feet of a home increase, the listing price will also increase. This regression line will help us to determine, for each one-unit of growth in the Predictor variable (square feet), how much of an increase there will be in the Response variable (listing price).
Median Housing Price Model for D. M. Pan National Real Estate Company 3 Data Collection The following data is a randomly collected sample of 50 counties in the United States, selected from 999 counties from the provided Real Estate County Data spreadsheet for 2019. The sample was determined using the Excel random function (=RAND), sorting the data from the lowest to the highest randomly generated number and selecting the first 50. Using the predictor variable (x), Median Square Feet, and the response variable (y), Median Listing Price, the below scatterplot was created to test the theory that our variables are related and create a linear model to predict median housing prices in 2019. - 1,000 2,000 3,000 4,000 5,000 6,000 $0 $100,000 $200,000 $300,000 $400,000 $500,000 $600,000 $700,000 $800,000 $900,000 Scatterplot of y vs. x Median Square Feet Meidan Lising Price Figure 1
Median Housing Price Model for D. M. Pan National Real Estate Company 4 Data Analysis Our data set needs to meet certain conditions to determine whether linear regression exists. The chosen sample must represent the population; there should be a linear relationship between the independent and dependent variables, and the variables need to be normally distributed. We can check this by creating a histogram of the residuals. Figure 2
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help