Summary MAT 240 Project One Median Housing Price Prediction Model for D. M. Pan National Real Estate Company

MAT 240 Report: Median Housing Price Prediction Model for D. M. Pan National Real Estate Company Southern New Hampshire University Introduction My report is to help D.M. Pan National Real Estate determine the use of square footage as a benchmark for listing prices on homes. They will be able to review predictions based on the median home prices from 2019 to use for this year s sales. Its also to provide a real-world linear regression research. Linear regression models are best used to show or predict the relationship between the median listing price and square footage of homes. When creating the scatter plot, I expect it to follow a linear pattern. The response or dependent variable is the median listing price and the predictor is the median square footage of homes. Data Collection I obtained my sample my using the random formula [=RAND()] in excel to the entire database and t