On the Weights for Characteristics and Comparables for Property Valuation using Quality Rating Valuation Estimation
:
https://doi.org/10.9744/ced.25.1.37-47Keywords:
Property Valuation, Quality Rating Valuation Estimation (QRVE), Gower Similarity index, Multiple Linear Regression (MLR), ClusteringAbstract
This study considers the problem of finding weights for building characteristics and compares buildings in property valuation to provide a more rigorous analytical foundation for a simple yet practical valuation technique knowns as Quality Rating Valuation Estimation (QRVE). Mathematically, we prove that the “best” characteristic weights can be obtained from Multiple Linear Regression Analysis (MRA) coefficients. Furthermore, by applying the Gower Similarity index and the Partition Around Medoid (PAM) clustering technique, the proposed algorithm provides an appropriate similarity of the weighing of compared buildings. The case studies illustrate a way to select a subset of characteristics when there are many of them with two numerical examples, as well as a complete modification of QRVE in conjunction with the grid adjustment technique. The modified QRVE proposal results in a very reasonable and high valuation performance of the building value estimate.
References
Kim, Y., Choi, S., and Yong, Y.M., Applying Comparable Sales Method to the Automated Estimation of Real Estate Prices, Sustainability, 12(14), 2020, p. 5679, https://doi.org/10.3390/su12145679
Tomić, H., Ivić, S.M., Roić, M., and Šiško, J., Developing an Efficient Property Valuation System using the LADM Valuation Information Model: A Croatian Case Study, Land Use Policy, 104(105368), 2021, ISSN 0264-8377, https://doi.org/10.1016/j.landusepol.2021.105368.
Deaconu, Adela, Buiga, A., and Tothăzan, H., Real Estate Valuation Models Performance in Price Prediction, International Journal of Strategic Property Management, 26(2), 2022, pp. 86 – 105, https://doi.org/10.3846/ijspm.2022.15962.
Lemen, J., 2020, https://ww3.rics.org/uk/en/ournals/property-journal/apc-5-valuation-methods. html
KPSPI, & MAPPI, Kode Etik Penilaian Indonesia dan Standar Penilaian Indonesia, Edisi VII, Jakarta: MAPPI, 2018.
Everett, C.H., Dowell, J.M., Bresnahan, C.A., Felthouse, W.W., Henry, E. E., Hutchinson, R.M., McNair, J.M., Meyer, H.F., Nisley, F., Rickert, G.E., Davis, W.D., Stahr, R.D., Tubbs W.A., Wilkinson, J.M., Easley, C.H., Miles, J.A., Garrett, H.J., Green, J.C., Heid, L.V., Orbaker, C.L., Scott, H.A., Thorkelson, G.F., and Davis, W.D., Professional Techniques Recommended in the Use of the Market Data Approach, Journal of ASFMRA, 30(1), 1966, pp. 108-111. https://www.jstor.org/stable/43757610
Hartoyo, Quality Rating Value Estimation – Suatu Teknik Penilaian Properti, Jurnal Survey dan Penilaian Properti, 2003, pp. 71–81. https://www.scribd.com/document/597999298/Quality-rating-value-estimation-Hartoyo
Surat Edaran Direktur Jenderal Pajak Nomor: SE-54/PJ/2016
Sudibyanung and Dewi, A.R., Modul Praktik Penilaian Tanah, Program Studi Diploma IV Pertanahan, Kementrian Agraria dan Tata Ruang/ BPN, Sekolah Tinggi Pertanahan Nasional, Yogyakarta, Indonesia, 2019.
Isaac, D. and O’Leary, J., Property Valuation Principles, Macmillan International Higher Education and Red Globe Press, 2012.
Munneke, H.J. and Almy, R., Market Analysis for Real Estate: Concepts and Applications in Valuation and Highest and Best Use, Chicago: The Appraisal Institut, 2016.
Cooper, The Future of Valuation Profession, AREA Press Release No. 553/2022: August 04, 2022, https://board.postjung.com/1415167
Ratcliff, R.U., Valuation for Real Estate Decisions, Democrat Press, 1972.
Sriboonjit, J. and Rattanaprichavej, N., Factor's Weight of Importance in the Weighted Quality Score (WQS) Technique: CBD's Serviced Apartment, International Journal of Information Business and Management, 5(4), 2013, https://papers.ssrn.com/sol3/papers.cfm?abstract_id=2403736.
BUSI 330 – Foundations of Real Estate Appraisal, Sauder Business School, University of British Columbia, https://professional.sauder.ubc.ca/re_creditprogram/course_resources/courses/content/330/qp_info.cfm
BUSI 344 – Statistical and Computer Applications in Valuation, Sauder Business School, University of British Columbia. https://professional. sauder.ubc.ca/re_creditprogram/course_resources/courses/content/344/qp_sample.pdf
Coldwell, P.F., Cannaday, R.E. and Wu, C., The Analytical Foundations of Adjustment Grid Methods, Real Estate Economics, 11(1), 1983, pp. 11–29. https://doi.org/10.1111/1540-6229.00277.
Vandell, Kerry D., Optimal Comparable Selection and Weighting in Real Property Valuation, Real Estate Economics, 19, 1991, pp. 213–239. https://doi.org/10.1111/1540-6229.00550.
Guijarro, Francisco, A Mean-Variance Optimization Approach for Residential Real Estate Valuation, Real Estate Management and Valuation, 29(3), 2021, pp. 13–28. https://doi.org/10.2478/remav-2021-0018.
Isakson, Hans, R., The Nearest Neighbors Appraisal Technique: An Alternative to the Adjustment Grid Methods, Real Estate Economics, American Real Estate and Urban Economics Association, 4(2), 1986, pp. 274–286. https://doi.org/10.1111/1540-6229.00387.
Isakson, Hans, R., Valuation Analysis of Commercial Real Estate using the Nearest Neighbors Appraisal Technique, Growth and Change, 19, 1988, pp. 11–24. https://doi.org/10.1111/j.1468-2257.1988.tb00466.x.
Cajias, M., Freudenreich, P., Freudenreich, A. et al., Liquidity and Prices: A Cluster Analysis of the German Residential Real Estate Market, Journal of Business Econonomics, 90, 202), pp. 1021–1056. https://doi.org/10.1007/s11573-020-00990-2.
Calka, Beata, Estimating Residential Property Values on the Basis of Clustering and Geostatistics, Geosciences, 9(3), 2019, p. 143, https://doi.org/10.3390/geosciences9030143.
Rahim, F.N.F. and Razali, M.F., Comparing the Performance of Similarity Measures in Sales Comparison Method, Proceedings of the ASEAN Post Graduate Conference (APGC) 2018, University of Malaya, Kuala Lumpur, 15 November 1472018.
Miller, Alan, J., Selection of Subsets of Regression Variables, Journal of the Royal Statistical Society, Series A (General), 3, 1984, pp. 389–425. https://doi.org/10.2307/2981576.
Das, A. and Kempe, D., Algorithms for Subset Selection in Linear Regression, Proceedings of the Fortieth Annual ACM symposium on Theory of computing (STOC '08), Association for Computing Machinery, New York, NY, USA, 2008, pp. 45–54. https://doi.org/10.1145/1374376. 1374384.
Park, Y.W. and Klabjan, D., Subset Selection for Multiple Linear Regression via Optimization, Journal of Global Optimization, 77, 2020, pp. 543– 574. https://doi.org/10.1007/s10898-020-00876-1.
Zhu, J., Wen, C., Zhu, J., Zhang, H., and Wang, X., A Polynomial Algorithm for Best-Subset Selection Problem, Proceedings of the National Academuy of Sciences (PNAS) of the United States of America, 117(52), 2020, pp. 33117–33123. https://doi.org/10.1073/pnas.2014241117.
Furnival, G.M. and Wilson, R.W., Regressions by Leaps and Bounds, Technometrics, 16(4), 1974, pp. 499 – 511. https://doi.org/10.2307/1267601.
Gower, J.C., A General Coefficient of Similarity and Some of Its Properties, Biometrics, 27(4), 1971, pp. 857–871. https://doi.org/10.2307/252 8823.
Podani, J., Extending Gower’s General Coefficient of Similarity to Ordinal Characters, Taxon, 48(2), 1999, pp. 331–340. https://doi.org/10.2307/1224438
Kaufman, L. and Rousseeuw, P., Finding Groups in Data: An Introduction to Cluster Analysis, John Wiley & Sons, 1990, 2005, https://onlinelibrary. wiley.com/doi/book/10.1002/9780470316801
Winanda, L.A.R., Model Penilaian Harga Jual Rumah Kelas Menengah (Tipe 36-45) dengan Analisis Regresi (Studi Kasus di Wilayah Kabupaten Sidoarjo), Jurnal PROKONS Politeknik Negeri Malang, 7(2), 2013, pp. 155–164. http://dx.doi.org/10.33795/prokons.v7i2.48
Shetty, D.V., Rao, B.P., Prakash, C., and Vaibhava, S., Multiple Regression Analysis to Predict the Value of a Residential Building and to Compare with the Conventional Method Values, Journal of Physics: Conference Series, 1706. 012118, 2020, https://10.1088/1742-6596/1706/1/012118.
Lumley, Thomas based on Fortran code by Alan Miller, Leaps: Regression Subset Selection, R Package, Version 3.1, 2020, https://CRAN.R-project.org/package=leaps
Laliberté, E., and Legendre, P., A Distance-based Framework for Measuring Functional Diversity from Multiple Traits, Ecology, 91, 2010, pp. 299– 305.
Laliberté, E., Legendre, P., and Shipley, B., FD: Measuring Functional Diversity from Multiple Traits and Other Tools for Functional Ecology, R Package, Version 1.0–12, 2014.
Maechler, M., Rousseeuw, P., Struyf, A., Hubert, M., and Hornik, K., Cluster: Cluster Analysis Basics and Extensions, R package, version 2.1.2, 2021.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Karina Agustin, Hanijanto Soewandi, Susan Widjojo
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:- Authors retain the copyright and publishing right, and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) followingthe publication of the article, as it can lead to productive exchanges, as well as earlier and greater citation of published work (See The Effect of Open Access).