The Real Estate Price Prediction Based on Multivariate Linear Regression Models
DOI:
https://doi.org/10.54691/bcpbm.v38i.3753Keywords:
Prediction; Regression Model; Linear Correlation.Abstract
The price of households had increased greatly as the demands in the market increased. Real estate had become the most popular method to resist inflation. Thus, more experts and scholars are working on the research in this area, including but not limited to find the future trends of housing prices and the possible bubble of housing prices. This paper will use the basic data regression model in Excel, powered by Microsoft, to find the factors that lead to the appreciation or depreciation of real estate, and three different methods of dealing with the data will be applied which are standardization, interception, and normal normalization. As a result of complex processes, normalization is the best way to deal with the data that was chosen from Kaggle. In the meantime, a linear correlation was done for checking the independency of each variable, and turned out to be successful. According to the analysis, an inverse relationship between the variables house age and distance nearest to the store was found, and the lower the house age is, the higher the price is, higher the house age is, lower the price is. The main aim of this paper is to investigate the relationship of the factors and their impact of them on the price of the house, was achieved and solved mathematically, and therefore, this research paper has found its goals. These results shed light on guiding further exploration of house price estimation.
Downloads
References
Most Expensive Housing Markets Globally 2020. Statista, Statista Research Department, 9 June 2022, Retrieved from: https://www.statista.com/statistics/1040698/most-expensive-property-markets-worldwide/.
Topic: Global Housing Market. Statista, Statista Research Department, 2 June 2022, Retrieved from: https://www.statista.com/topics/5466/global-housing-market/#topicHeader__wrapper.
Campisi Natalie. Will the Housing Market Crash? Experts Give 5-Year Predictions. Forbes, Forbes Magazine, 16 Aug. 2022, Retrieved from: https://www.forbes.com/advisor/mortgages/real-estate/will-housing-market-crash/.
Liu Chang, and Wei Xiong. “China's Real Estate Market National Bureau of Economic Research.” Https://Www.nber.org/System/Files/working_papers/w25297/w25297.Pdf, Nber.org, Nov. 2018, https://www.nber.org/system/files/working_papers/w25297/w25297.pdf.
Hale Danielle, and Sabrina Speianu. 2022 Housing Market Predictions and Forecast. Realtor.com Economic Research, Realtor.com, 6 July 2022, Retrieved from: https://www.realtor.com/research/2022-national-housing-forecast-midyear-update/.
Bruce, Algor. Real Estate Price Prediction. Kaggle, 8 Dec. 2018, Retrieved from: https://www.kaggle.com/datasets/quantbruce/real-estate-price-prediction.
McLeod S. A. 2019, May 20. What a p-value tells you about statistical significance. Simply Psychology. Retrieved from: www.simplypsychology.org/p-value.html
Team, Towards AI. “How, When, and Why Should You Normalize / Standardize / Rescale Your Data?” Retrieved from: Towards AI, 29 May 2020, Retrieved from: https://towardsai.net/p/data-science/how-when-and-why- should-you-normalize-standardize-rescale-your-data-3f083def38ff.
“Pearson Correlation Coefficient: Free Examples.” QuestionPro, 22 June 2022, Retrieved from: https://www.questionpro.com/blog/pearson-correlation-coefficient/.
Zach. “How to Interpret the Intercept in a Regression Model (with Examples).” Statology, 22 June 2021, Retrieved from: https://www.statology.org/intercept-in-regression/.






