House Price Prediction using Multiple Linear Regression and KNN

Fransiskus Dwi Febriyanto, Endroyono Endroyono, Yoyon Kusnendar

Abstract


The transition of BPHTB management from central taxes to regional taxes is a continuation of the regional autonomy policy. The difference between the market value and the prevailing NJOP poses a challenge for the Sintang District Government in determining the Tax Object Acquisition Value (NPOP) as the basis for imposing BPHTB. Machine learning has been extensively explored for predictions and can be an alternative that can help predict NPOP, especially house prices. This study uses backward elimination and forward selection methods to select the features used in this study and multiple linear regression and K-Nearest Neighbor methods to make house price prediction models. The results of model performance measurement using RMSE, Multiple Linear Regression method with feature selection using backward elimination resulted in a better model with an RMSE value of 44.02 (million rupiahs) and an R2 value of 0.707.

Full Text:

PDF

References


UU RI, “Undang-Undang Nomor 28 Tahun 2009 Tentang Pajak Daerah dan Retribusi Daerah.” Indonesia, 2009.

Badan Pusat Statistik, “Kabupaten Sintang Dalam Angka 2020,” 2020. doi: 10.22146/mgi.34838.

Pemerintah Kabupaten Sintang, Peraturan Daerah No 1 Tahun 2011 Tentang Bea Perolehan Hak Atas Tanah dan Bangunan. Sintang, 2011.

T. Afriyandi, “Kewenangan Pemerintah Daerah Dalam Menentukan Harga Jual Dalam Transaksi Jual Beli Tanah Dan Atau Bangunan,” J. Huk. Volkgeist, vol. 3, no. 1, pp. 29–43, Dec. 2018, doi: 10.35326/volkgeist.v3i1.112.

D. G. Raja Guk-Guk, I. Isnaini, and M. C. Ramadhan, “Efektifitas Validasi Bea Perolehan Hak atas Tanah dan Bangunan terhadap Ketidaksesuaian Nilai Objek Pajak dalam Akta Jual Beli dengan Harga Sebenarnya,” J. Educ. Hum. Soc. Sci., vol. 4, no. 2, pp. 875–885, Oct. 2021, doi: 10.34007/jehss.v4i2.763.

D. Erlinda, F. Wisnaeni, and N. Maharani Sukma, “Pelaksanaan Verifikasi Peralihan Hak Atas Tanah Dan Bangunan (Bphtb) Di Kabupaten Bogor,” Notarius, vol. 13, no. 2, pp. 946–960, 2020, doi: 10.14710/nts.v13i2.31305.

M. D. Mankad, “Comparing OLS based hedonic model and ANN in house price estimation using relative location,” Spat. Inf. Res., vol. 30, no. 1, pp. 107–116, Feb. 2022, doi: 10.1007/s41324-021-00416-3.

R. B. Abidoye and A. P. C. Chan, “Improving property valuation accuracy: A comparison of hedonic pricing model and artificial neural network,” Pacific Rim Prop. Res. J., vol. 24, no. 1, 2018, doi: 10.1080/14445921.2018.1436306.

G. Hayrullahoglu, Y. Aliefendioglu, H. Tanrivermis, and A. C. Hayrullahoglu, “Estimation of the Hedonic Valuation Model in Housing Markets: The Case of Cukurambar Region in Cankaya District of Ankara Province,” Ecoforum, vol. 7, no. 1, 2018.

M. D. Mankad, “Comparing OLS based hedonic model and ANN in house price estimation using relative location,” Spat. Inf. Res., 2021, doi: 10.1007/s41324-021-00416-3.

M. Doszyń, “Might expert knowledge improve econometric real estate mass appraisal?,” J. Real Estate Financ. Econ., 2022, doi: 10.1007/s11146-022-09891-3.

W. Zhao, C. Sun, and J. Wang, “The research on price prediction of second-hand houses based on KNN and stimulated annealing algorithm,” Int. J. Smart Home, vol. 8, no. 2, 2014, doi: 10.14257/ijsh.2014.8.2.19.

I. Wahyuni, N. Nafi’iyah, and Masruroh, “Sistem Peramalan Penjualan Perumahan di Kabupaten Lamongan dengan Menggunakan Metode Regresi Linier Berganda,” Semin. Nas. Sist. Inf. 2019, no. September, pp. 1969–1973, 2019.

N. N. Ghosalkar and S. N. Dhage, “Real Estate Value Prediction Using Linear Regression,” Proc. - 2018 4th Int. Conf. Comput. Commun. Control Autom. ICCUBEA 2018, pp. 1–5, 2018, doi: 10.1109/ICCUBEA.2018.8697639.

H. Feng et al., “Estimation of forest aboveground biomass by using mixed-effects model,” Int. J. Remote Sens., vol. 42, no. 22, pp. 8675–8690, 2021, doi: 10.1080/01431161.2021.1984611.

I. Kurniawan and A. F. Abror, “Komparasi Metode Kombinasi Seleksi Fitur dan Machine Learning K-Nearest Neighbor pada Dataset Label Hours Software Effort Estimation,” Explor. J. Sist. Inf. dan Telemat., vol. 10, no. 2, Oct. 2019, doi: 10.36448/jsit.v10i2.1314.

S. Santoso, Mastering SPSS 18. Jakarta: PT Elex Media Komputindo, 2010.

D. Werdiastu, D. E. Ratnawati, and B. Rahayudi, “Estimasi Hasil Produksi Benih Berdasarkan Karakteristik Tanaman Kenaf Menggunakan Metode Backpropagation (Studi Kasus: Balai Tanaman Pemanis dan Serat Kota Malang),” 2018. [Online]. Available: http://j-ptiik.ub.ac.id

B. Gunawan, H. Sasty, P. #2, E. Esyudha, and P. #3, “JEPIN (Jurnal Edukasi dan Penelitian Informatika) Sistem Analisis Sentimen pada Ulasan Produk Menggunakan Metode Naive Bayes,” vol. 4, no. 2, pp. 17–29, 2018.

A. Shoddiq Bayu Asmoro, W. Sakti Gunawan Irianto, U. Pujianto, J. Semarang No, and J. Timur, “Perbandingan Kinerja Hasil Seleksi Fitur pada Prediksi Kinerja Akademik Siswa Berbasis Pohon Keputusan,” JEPIN (Jurnal Edukasi dan Penelit. Inform. , vol. 4, no. 2, pp. 84–89, Dec. 2018, [Online]. Available: www.kaggle.com/aljarah/xAPI-Edu-Data

A. Bode, “Perbandingan Metode Prediksi Support Vector Machine dan Linear Regression Menggunakan Backward elimination pada Produksi Minyak Kelapa,” Simtek J. Sist. Inf. dan Tek. Komput., vol. 4, no. 2, pp. 104–107, Oct. 2019, doi: 10.51876/simtek.v4i2.57.

S. Haloui and A. E. El Moudden, “An optimal prediction model’s credit risk: The implementation of the backward elimination and forward regression method,” Int. J. Adv. Comput. Sci. Appl., no. 2, pp. 457–467, 2020, doi: 10.14569/ijacsa.2020.0110259.

R. Sanjaya and F. Fitriyani, “Prediksi Bedah Toraks Menggunakan Seleksi Fitur Forward Selection dan K-Nearest Neighbor,” J. Edukasi dan Penelit. Inform., vol. 5, no. 3, 2019, doi: 10.26418/jp.v5i3.35324.

J. Han, M. Kamber, and J. Pei, Data Mining: Concepts and Techniques. 2012. doi: 10.1016/C2009-0-61819-5.

C. Mishra, L. Mohanty, S. Rath, R. Patnaik, and R. Pradhan, “Application of backward elimination in multiple linear regression model for prediction of stock index,” in Smart Innovation, Systems and Technologies, 2021, vol. 153. doi: 10.1007/978-981-15-6202-0_56.

N. Koesoemaningroem, Endroyono, and S. Mardi Susiki Nugroho, “Peramalan Pencematan Udara di Kota Surabaya Menggunakan Metode DsArima dengan Pendekatan Percentile Error Bootstrap (PEB),” J. Teknol. Inf. dan Ilmu Komput., vol. 8, no. 5, pp. 987–994, 2021, doi: 10.25126/jtiik.202185216.




DOI: https://doi.org/10.12962/jaree.v7i1.328

Refbacks

  • There are currently no refbacks.


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.