IDEAS home Printed from https://ideas.repec.org/a/bla/reesec/v52y2024i5p1308-1339.html

Combining machine learning and econometrics: Application to commercial real estate prices

Author

Listed:
  • Marc Francke
  • Alex van de Minne

Abstract

In this article, we combine a random effects model with different machine learning algorithms via an iterative process when predicting commercial real estate asset values. Using both random effects and machine learning allows us to combine the strengths of both approaches. The random effects will be used to estimate a common trend, property type trends, location value, and property random effects for properties that sold more than once. The machine learning algorithm will fit the observed characteristics (features) in a complex nonlinear fashion. The model is applied to a small sample of 2652 transactions in Phoenix (AZ) between 2001 and 2021. We only observe a limited number of property characteristics. The average out‐of‐sample MAPE is below 11%, which is as good or even better compared to the average appraisal error found in literature. The out‐of‐sample MAPE is even 9% for properties that sold more than once in the training set. In addition, our model provides indexes and locational heatmaps. These have their own uses and cannot be obtained with standard machine learning algorithms.

Suggested Citation

  • Marc Francke & Alex van de Minne, 2024. "Combining machine learning and econometrics: Application to commercial real estate prices," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 52(5), pages 1308-1339, September.
  • Handle: RePEc:bla:reesec:v:52:y:2024:i:5:p:1308-1339
    DOI: 10.1111/1540-6229.12483
    as

    Download full text from publisher

    File URL: https://doi.org/10.1111/1540-6229.12483
    Download Restriction: no

    File URL: https://libkey.io/10.1111/1540-6229.12483?utm_source=ideas
    LibKey link: if access is restricted and if your library uses this service, LibKey will redirect you to where you can use your library subscription to access this item
    ---><---

    References listed on IDEAS

    as
    1. John M. Clapp & Carmelo Giaccotto, 1999. "Revisions in Repeat‐Sales Price Indexes: Here Today, Gone Tomorrow?," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 27(1), pages 79-104, March.
    2. Cannon, Susanne & Col, Rebel A., 2011. "How accurate are commercial-real-estate appraisals? evidence from 25 years of NCREIF sales data," MPRA Paper 32589, University Library of Munich, Germany.
    3. Albert Saiz, 2010. "The Geographic Determinants of Housing Supply," The Quarterly Journal of Economics, President and Fellows of Harvard College, vol. 125(3), pages 1253-1296.
    4. Alex van de Minne & Marc Francke & David Geltner, 2022. "Forecasting US Commercial Property Price Indexes Using Dynamic Factor Models," Journal of Real Estate Research, Taylor & Francis Journals, vol. 44(1), pages 29-55, January.
    5. Marc Francke, 2010. "Repeat Sales Index for Thin Markets," The Journal of Real Estate Finance and Economics, Springer, vol. 41(1), pages 24-52, July.
    6. Julian Besag & Jeremy York & Annie Mollié, 1991. "Bayesian image restoration, with two applications in spatial statistics," Annals of the Institute of Statistical Mathematics, Springer;The Institute of Statistical Mathematics, vol. 43(1), pages 1-20, March.
    7. Marc Francke & Alex Van De Minne, 2022. "Daily appraisal of commercial real estate a new mixed frequency approach," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 50(5), pages 1257-1281, September.
    8. Juergen Deppner & Marcelo Cajias, 2022. "Accounting for Spatial Autocorrelation in Algorithm-Driven Hedonic Models: A Spatial Cross-Validation Approach," ERES 2022_84, European Real Estate Society (ERES).
    9. Håvard Rue & Sara Martino & Nicolas Chopin, 2009. "Approximate Bayesian inference for latent Gaussian models by using integrated nested Laplace approximations," Journal of the Royal Statistical Society Series B, Royal Statistical Society, vol. 71(2), pages 319-392, April.
    10. Alex Minne & Marc Francke & David Geltner & Robert White, 2020. "Using Revisions as a Measure of Price Index Quality in Repeat-Sales Models," The Journal of Real Estate Finance and Economics, Springer, vol. 60(4), pages 514-553, May.
    11. Guo, Xiaoyang & Zheng, Siqi & Geltner, David & Liu, Hongyu, 2014. "A new approach for constructing home price indices: The pseudo repeat sales model and its application in China," Journal of Housing Economics, Elsevier, vol. 25(C), pages 20-38.
    12. Steven Peterson & Albert Flanagan, 2009. "Neural Network Hedonic Pricing Models in Mass Real Estate Appraisal," Journal of Real Estate Research, Taylor & Francis Journals, vol. 31(2), pages 147-164, January.
    13. Marc K. Francke & Alex Minne, 2017. "The Hierarchical Repeat Sales Model for Granular Commercial Real Estate and Residential Price Indices," The Journal of Real Estate Finance and Economics, Springer, vol. 55(4), pages 511-532, November.
    14. Steven Peterson & Albert B. Flanagan, 2009. "Neural Network Hedonic Pricing Models in Mass Real Estate Appraisal," Journal of Real Estate Research, American Real Estate Society, vol. 31(2), pages 147-164.
    15. Marc K. Francke & Gerjan A. Vos, 2004. "The Hierarchical Trend Model for Property Valuation and Local Price Indices," The Journal of Real Estate Finance and Economics, Springer, vol. 28(2_3), pages 179-208, March.
    16. Marc Francke & Alex Van de Minne, 2021. "Modeling unobserved heterogeneity in hedonic price models," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 49(4), pages 1315-1339, December.
    17. Yongheng Deng & John Quigley, 2008. "Index Revision, House Price Risk, and the Market for House Price Derivatives," The Journal of Real Estate Finance and Economics, Springer, vol. 37(3), pages 191-209, October.
    18. Sendhil Mullainathan & Jann Spiess, 2017. "Machine Learning: An Applied Econometric Approach," Journal of Economic Perspectives, American Economic Association, vol. 31(2), pages 87-106, Spring.
    19. Felix Lorenz & Jonas Willwersch & Marcelo Cajias & Franz Fuerst, 2023. "Interpretable machine learning for real estate market analysis," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 51(5), pages 1178-1208, September.
    20. Eric Clapham & Peter Englund & John M. Quigley & Christian L. Redfearn, 2006. "Revisiting the Past and Settling the Score: Index Revision for House Price Derivatives," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 34(2), pages 275-302, June.
    21. R. Kelley Pace & Darren Hayunga, 2020. "Examining the Information Content of Residuals from Hedonic and Spatial Models Using Trees and Forests," The Journal of Real Estate Finance and Economics, Springer, vol. 60(1), pages 170-180, February.
    22. Susanne, Cannon & Rebel, Cole, 2011. "How Accurate Are Commercial Real Estate Appraisals? Evidence from 25 Years of NCREIF Sales Data," MPRA Paper 52621, University Library of Munich, Germany, revised 25 May 2011.
    23. Hal R. Varian, 2014. "Big Data: New Tricks for Econometrics," Journal of Economic Perspectives, American Economic Association, vol. 28(2), pages 3-28, Spring.
    24. Elaine M. Worzala & Margarita Lenk & Ana Silva, 1995. "An Exploration of Neural Networks and Its Application to Real Estate Valuation," Journal of Real Estate Research, American Real Estate Society, vol. 10(2), pages 185-202.
    Full references (including those not matched with items on IDEAS)

    Citations

    Citations are extracted by the CitEc Project, subscribe to its RSS feed for this item.
    as


    Cited by:

    1. Hendrik Jenett & Cathrine Nagl & Maximilian Nagl & S. McKay Price & Wolfgang Schaefers, 2026. "Dynamics of REIT Returns and Volatility: Analyzing Time-Varying Drivers Through an Explainable Machine Learning Approach," The Journal of Real Estate Finance and Economics, Springer, vol. 72(1), pages 1-40, January.
    2. Dieudonné Tchuente, 2026. "Real Estate Automated Valuation Model with Explainable Artificial Intelligence Based on Shapley Values," The Journal of Real Estate Finance and Economics, Springer, vol. 72(3), pages 567-605, April.

    Most related items

    These are the items that most often cite the same works as this one and are cited by the same works as this one.
    1. Felipe D. Calainho & Alex M. Minne & Marc K. Francke, 2024. "A Machine Learning Approach to Price Indices: Applications in Commercial Real Estate," The Journal of Real Estate Finance and Economics, Springer, vol. 68(4), pages 624-653, May.
    2. Marc Francke & Lyndsey Rolheiser & Alex Minne, 2025. "Estimating Census Tract House Price Indexes: A New Spatial Dynamic Factor Approach," The Journal of Real Estate Finance and Economics, Springer, vol. 70(3), pages 483-514, April.
    3. Alex Minne & Marc Francke & David Geltner & Robert White, 2020. "Using Revisions as a Measure of Price Index Quality in Repeat-Sales Models," The Journal of Real Estate Finance and Economics, Springer, vol. 60(4), pages 514-553, May.
    4. Juergen Deppner & Benedict Ahlefeldt-Dehn & Eli Beracha & Wolfgang Schaefers, 2025. "Boosting the Accuracy of Commercial Real Estate Appraisals: An Interpretable Machine Learning Approach," The Journal of Real Estate Finance and Economics, Springer, vol. 71(2), pages 314-351, August.
    5. Marc K. Francke & Alex Minne, 2017. "The Hierarchical Repeat Sales Model for Granular Commercial Real Estate and Residential Price Indices," The Journal of Real Estate Finance and Economics, Springer, vol. 55(4), pages 511-532, November.
    6. Juergen Deppner & Marcelo Cajias, 2024. "Accounting for Spatial Autocorrelation in Algorithm-Driven Hedonic Models: A Spatial Cross-Validation Approach," The Journal of Real Estate Finance and Economics, Springer, vol. 68(2), pages 235-273, February.
    7. Marc Francke & Alex Van de Minne, 2021. "Modeling unobserved heterogeneity in hedonic price models," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 49(4), pages 1315-1339, December.
    8. Dragana Cvijanović & Stanimira Milcheva & Alex Minne, 2022. "Preferences of Institutional Investors in Commercial Real Estate," The Journal of Real Estate Finance and Economics, Springer, vol. 65(2), pages 321-359, August.
    9. David Geltner & Anil Kumar & Alex M. Van de Minne, 2020. "Riskiness of Real Estate Development: A Perspective from Urban Economics and Option Value Theory," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 48(2), pages 406-445, June.
    10. Daniel Broxterman & William Larson & Anthony Yezer, 2026. "Characteristics of a Sufficient Statistic to Measure City Housing Prices," NBER Chapters, in: Measurement of Housing and the Housing Sector, National Bureau of Economic Research, Inc.
    11. Lozano, Francisco Javier, 2025. "Índice de precios de viviendas nuevas en Santiago basado en la metodología de ventas repetidas [New housing price index in Santiago based on the repeat-sales methodology]," MPRA Paper 127115, University Library of Munich, Germany.
    12. Liang Peng, 2020. "Benchmarking Local Commercial Real Estate Returns: Statistics Meets Economics," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 48(4), pages 1004-1029, December.
    13. Marc Francke & Alex Van De Minne, 2022. "Daily appraisal of commercial real estate a new mixed frequency approach," Real Estate Economics, American Real Estate and Urban Economics Association, vol. 50(5), pages 1257-1281, September.
    14. Reza Amindarbari & Perver Baran & Ross K. Meentemeyer, 2023. "Spatially disaggregated simulation of interactions between home prices and land-use change," Environment and Planning B, , vol. 50(7), pages 1879-1897, September.
    15. Arnaud Simon, 2009. "Quantifying the reversibility phenomenon for the repeat-sales index," Journal of Real Estate Research, American Real Estate Society, vol. 31(1), pages 27-62.
    16. Dorinth W. Dijk & David M. Geltner & Alex M. Minne, 2022. "The Dynamics of Liquidity in Commercial Property Markets: Revisiting Supply and Demand Indexes in Real Estate," The Journal of Real Estate Finance and Economics, Springer, vol. 64(3), pages 327-360, April.
    17. Cihan Çılgın & Hadi Gökçen, 2025. "A Hybrid Machine Learning Model Architecture with Clustering Analysis and Stacking Ensemble for Real Estate Price Prediction," Computational Economics, Springer;Society for Computational Economics, vol. 66(1), pages 127-178, July.
    18. Zhu, Bing & van Dijk, Dorinth & Lizieri, Colin, 2024. "Price diffusion across international private commercial real estate markets," Journal of International Money and Finance, Elsevier, vol. 140(C).
    19. Marc Francke, 2010. "Repeat Sales Index for Thin Markets," The Journal of Real Estate Finance and Economics, Springer, vol. 41(1), pages 24-52, July.
    20. Ghysels, Eric & Plazzi, Alberto & Valkanov, Rossen & Torous, Walter, 2013. "Forecasting Real Estate Prices," Handbook of Economic Forecasting, in: G. Elliott & C. Granger & A. Timmermann (ed.), Handbook of Economic Forecasting, edition 1, volume 2, chapter 0, pages 509-580, Elsevier.

    More about this item

    Statistics

    Access and download statistics

    Corrections

    All material on this site has been provided by the respective publishers and authors. You can help correct errors and omissions. When requesting a correction, please mention this item's handle: RePEc:bla:reesec:v:52:y:2024:i:5:p:1308-1339. See general information about how to correct material in RePEc.

    If you have authored this item and are not yet registered with RePEc, we encourage you to do it here. This allows to link your profile to this item. It also allows you to accept potential citations to this item that we are uncertain about.

    If CitEc recognized a bibliographic reference but did not link an item in RePEc to it, you can help with this form .

    If you know of missing items citing this one, you can help us creating those links by adding the relevant references in the same way as above, for each refering item. If you are a registered author of this item, you may also want to check the "citations" tab in your RePEc Author Service profile, as there may be some citations waiting for confirmation.

    For technical questions regarding this item, or to correct its authors, title, abstract, bibliographic or download information, contact: Wiley Content Delivery (email available below). General contact details of provider: https://edirc.repec.org/data/areueea.html .

    Please note that corrections may take a couple of weeks to filter through the various RePEc services.

    IDEAS is a RePEc service. RePEc uses bibliographic data supplied by the respective publishers.