GISValTech2025

Introduction to Spatial AVMs in Excel: Incorporating Spatial Variables into Regression Analysis (Afternoon Half-Day) Workshop
Thursday, March 6, 2025 - 1:00 - 5:00 PM
Instructors: Paul Bidanset, Founder/Research Scientist, Center for Appraisal Research and Technology
Daniel Fasteen, Ph.D., Senior Research Scientist, Tyler Technologies

In this hands-on workshop, participants will learn how to incorporate location-based variables into regression models to improve the accuracy and precision of property valuations. We will cover a range of methods for accounting for spatial factors, including neighborhood dummy variables, interaction terms, and proximity measures.

Participants will explore how proximity to highways, city centers, public transportation, and other points of interest can influence property values, and how to effectively represent these influences in a regression model. We will also compare different proximity measures such as straight-line (as- the-crow-flies) distance, drive time, drive distance, and walking distance, discussing the benefits and trade-offs of each approach.

Throughout the workshop, we will address common pitfalls in spatial modeling and emphasize best practices for ensuring that location is properly considered in valuation models. Participants will also gain experience in interpreting model outputs and coefficients, ensuring they are equipped to apply these techniques in real-world valuation scenarios.

By the end of the session, participants will have a solid foundation in spatial regression modeling and the tools to incorporate spatial variables into their own valuation models, resulting in more accurate and defensible property assessments.