Showing posts with label Automated Valuation Modeling. Show all posts
Showing posts with label Automated Valuation Modeling. Show all posts

Saturday, October 31, 2026

This weekend only — 50% off five books (PDF downloads)

 A mix of practical valuation modeling titles and other works. All proceeds support charities, including Save the Children.

Titles included:

1. 101 Key Terms for Valuation Modeling: A Practical Desktop Reference for Mass Appraisal, CAMA, and AVM Practitioners

Link: https://payhip.com/b/6KT2Z

2. Beyond the Median: How to Unmask the Multi-Million Dollar Appeals Tsunami in Modern Mass Appraisal

Link: https://payhip.com/b/PcIyf

3. Equalization Valuation Modeling (EVM) for Smaller and Mid-Sized Jurisdictions: Foundations & Model Development

Link: https://payhip.com/b/8foNn

4. Valuation Modeling: The Perfect Crossover between AVM and CAMA

Link: https://payhip.com/b/3G9gs

5. Country Analysis: Decoding the World with Data

Link: https://payhip.com/b/agvPS

Important: Use coupon code CHARITY50 at checkout to get 50% off.

Direct download via Payhip. Campaign ends Sunday night.

If you’ve been meaning to pick them up, or know someone who could benefit, now is a good time.

Thank you for your support.
Sid


Thursday, July 16, 2026

Introducing DEMA™ (Double-Entry Mass Appraisal)

What if the traditional one-step CAMA approach is the root cause of the appeals tsunami?

We’ve been building a better way.

In Sessions 4A and 4B, we demonstrated the complete Double-Entry Mass Appraisal (DEMA™) protocol:

· First Entry (Sales-Based Modeling): Builds the tentative roll with econometric soundness (BLUE status) and IAAO compliance.

· Second Entry (Population-Based Equalization): Cleans the roll by identifying and correcting population-level distortions before it is finalized.

This two-sided ledger approach — DEMA™ — is the true Nirvana of modern mass appraisal: proactive equity instead of reactive defense.

Session 4C, the grand finale of Phase 1, will deliver the final Champ-Challenger showdown between the Central Taxing District and the Town Taxing District. This direct comparison will identify the major faultlines when the jurisdiction roll is generated by two separate models (in-town vs. suburbs). 4C will complete our end-to-end DEMA™ solution next week.

To read Session 4B and run the DEMA™ Protocol on your own database:

Link to Substack

Link to Patreon

If you work in assessing, serve on a VAB or Review Commission, or consult in this space, DEMA™ offers a practical path to stronger rolls and fewer appeals.

Tag colleagues who should see this series:

#DEMA #CAMA #IAAO #MassAppraisal #PropertyAssessment #ValuationModeling #VAB 

Wednesday, July 15, 2026

Why Mass Appraisal Needs Double-Entry Valuation Modeling

Would you let a Fortune 500 company manage its financial ledger using single-entry bookkeeping?

Of course not. Tracking cash flowing in without a balancing entry, a trial balance, or a structural balance sheet is an immediate recipe for systemic failure.

Yet, every single year, multi-billion-dollar tax jurisdictions run their property rolls on the exact same single-entry mindset.

Legacy CAMA practices do this by default:

1.   They look at transaction data (sales).

2.   They run a baseline regression.

3.   They print the Tentative Roll (the first entry).

4.   They stop right there.

Stopping at the first entry means you are flying completely blind. You have no balancing ledger to check if those values are mathematically stable or legally uniform across the remaining 95% of the unsold population. You only find out the ledger is broken when an appeals tsunami hits the Value Adjustment Board (VAB) or the Review Commission.

In Session 4B, we introduce modern Double-Entry Valuation Modeling. We show you how to take that initial generative sales engine and systematically reconcile it against a full population dataset of 60,870 properties.

If you want to move past single-entry mass appraisal and learn how to build an unassailable, balanced valuation ledger that stops litigation before it starts, the Session 4B blueprint is officially live.

The Executive Summary remains free for everyone (use either link below):

Link to Patreon

Link to Substack


Tuesday, July 14, 2026

How Resilient is Your Tax Roll when subjected to a Rigorous Population-Based Audit?

 Session 4B is Now Live!

Many mass appraisal systems look brilliant on paper. They boast high R^2 values, strong global F-statistics, and highly "significant" variables. But beneath the surface of these global metrics often lie structural anomalies, negative coefficient traps, and systemic equity distortions that leave jurisdictions incredibly vulnerable to appeals and litigation.

In Session 4B of our Equalization Valuation Modeling series, we move from sales-based modeling (Session 4A) to a comprehensive population dataset of 60,870 Single-Family Residences.

Using a population-based approach, this session provides a step-by-step blueprint for assessment staff, independent consultants, Review Commissioners, and Value Adjustment Board (VAB) members to conduct a forensic audit of a tentative roll, diagnose legacy computer-assisted mass appraisal (CAMA) failures, and protect the integrity of the jurisdiction.

In this session, we dive deep into:

The Continuous Variable Riddle: Why legacy linear models produce economic absurdities (like negative land values) and how to fix them using our proprietary, objective, stratification method. 

Quantifying Systemic Exposure: How a seemingly simple binary variable can unmask massive, multi-billion dollar horizontal and vertical equity risks across a population. 

The 2-Pass JVR Protocol: How executing a strict two-pass regression with Just Value Ratio (JVR) analysis mathematically purges cross-jurisdictional noise and stabilizes the roll.

This session also sets the stage for our upcoming grand finale: The Session 4C Champ-Challenger Showdown.

If you are an assessor, independent analyst, or oversight commissioner looking for unassailable, platform-agnostic modeling frameworks to navigate today's complex valuation landscape, this playbook is for you.

Read the Executive Summary for Free and unlock the full Premium Deep Dive here:

Substack Link

Patreon Link


Wednesday, June 17, 2026

Session 1: Platform-Agnostic Equalization Valuation Modeling is Now Live (and 100% Free!!)

 We’re Live — Session 1 is Now Available (100% Free)

Platform-Agnostic Equalization Valuation Modeling: Tools for Assessing Staff, VABs, Review Commissions & Independent Consultants

Today marks the official launch of our new 8-session series.

If you work for a small or mid-sized assessing jurisdiction and are trying to understand how the CAMA system produces values, serve on a Review Commission, are part of a Value Adjustment Board, or work as an independent consultant, this series was built for you.

Session 1 is completely free and unlocked for everyone.

In this foundational session, we demonstrate a practical, transparent, Excel-based (and platform-agnostic) approach to building Equalization Valuation Models using your jurisdiction’s own Just Values.

In Session 1, you will learn:

· How to construct a proper equalization dataset

· The complete 2-Pass Forensic Outlier Protocol

· A striking real-world “Wake-Up Call” sample showing current misalignments

· How the model improves dramatically after cleaning (R² to 93.78%, much tighter uniformity)

· Just Value Ratio (JVR) diagnostics with clear interpretation

·        Step-by-step Excel instructions (Data Analysis ToolPak)

This is your independent, defensible toolset — no vendor lock-in required. Works in Excel for smaller offices and scales to SPSS/SAS for larger jurisdictions.

Download Session 1 for Free Now (Patreon or Substack) →

https://www.patreon.com/SidSom/posts/platform-tools-161198809

https://sidsom.substack.com/p/platform-agnostic-equalization-valuation-ea3?r=7xq68s

Fellow coffee lovers: You can also support this ongoing work (and share a virtual coffee with me) via Buy Me a Coffee. Every bit helps keep this mission — helping dreamers achieve their goals — moving forward.

https://buymeacoffee.com/sidsom/platform-agnostic-equalization-valuation-modeling-tools-assessing-staff-vabs-review-commissions-independent-consultants

A portion of the proceeds from the full series will support charitable causes.

The full 8-session series will continue weekly, taking you from model development to powerful applications: Regression Comps (bottom-up) and Ratio Challenges (top-down).

This is structural empowerment in the back end of mass appraisal.

If you care about fair, transparent, and defensible property valuation, join us.

Session 1 is available right now. Let’s get started.

Tag colleagues who should read this post.

Friday, December 5, 2025

Book: Econometric Modeling: Achieving BLUE Status through Housing Case Studies

Link to the Kindle version

Book Summary

"Econometric Modeling: Achieving BLUE Status through Housing Case Studies" provides the essential, step-by-step methodology required for students, quantitative analysts, and economists to construct, validate, and defend statistical models that adhere to the highest standards of econometric theory—specifically, the Best Linear Unbiased Estimator (BLUE).

This book is dedicated to bridging the gap between OLS theory and practical, high-stakes empirical analysis. Comprising eleven comprehensive chapters, the book progresses through the following core stages:

Part I: Establishing the Foundation (BLUE Methodology)

We begin by establishing the mathematical and operational defense of Ordinary Least Squares (OLS) regression as the optimal tool for linear estimation. This section introduces a systematic framework for rigorous data preparation, including the Two-Pass Methodology for outlier removal and error-distribution normalization, and a critical approach to variable selection that structurally safeguards the model against pervasive issues such as Omitted Variable Bias (OVB) and Multicollinearity.

Part II: Advanced Coding and Coefficient Generation

The core of the methodology is demonstrated through the systematic application of advanced categorical coding techniques—including Dummy, Effect, One-Hot, and Ordinal Coding. We show how these techniques are meticulously applied to generate clear, statistically significant, and explicit dollar coefficients for both continuous and discrete attributes, while maintaining the model's linearity and maximizing explanatory power.

Part III: Validation, Application, and Compliance

The final chapters transition from estimation to proof. We provide rigorous diagnostics to confirm adherence to the core OLS assumptions (Homoscedasticity and Normality) and establish external validity by demonstrating that the sales sample is a precise microcosm of the larger population. The book concludes by demonstrating the model's application—from top-down (population-level) performance metrics to the creation of bottom-up, objective valuation grids—ensuring that the final derived coefficients are fully validated and compliant with the BLUE requirements.

This text is a crucial resource for any analyst or technician seeking to move beyond simple regression and master the creation of statistically defensible, unbiased econometric models.

Saturday, September 20, 2025

Book: Making Valuation Modeling (AVM and CAMA) More Econometric

Link to the Kindle version

Book Summary

Making Valuation Modeling (AVM and CAMA) More Econometric is the definitive guide to transforming proprietary black-box valuation systems into transparent, statistically defensible models.
This book provides a systematic, step-by-step framework for achieving 
Best Linear Unbiased Estimator (BLUE) status for your valuation coefficients. You'll master the econometric discipline required to:

  • Establish Structural Integrity: Use the Two-Pass Regression Approach and the Foundational/Conditional Variable Strategy to eliminate Omitted Variable Bias and ensure model stability.
  • Generate Transparent Adjustments: Apply advanced Dummy, Effect, and One-Hot Coding to replace subjective heuristics with explicit, data-driven dollar adjustments for time and location.
  • Prove Defensibility and Equity: Validate your model using industry-standard checks, including the Sales Representativeness Test and the IAAO Guidelines (COD & PRD), to prove high uniformity and fairness across value ranges.

This book is a call to action for mass appraisal professionals, AVM scientists, and risk managers to move beyond simple prediction and embrace the econometric imperative. It will help build models that are not only accurate but also equitable, transparent, and legally defensible.

Thursday, September 11, 2025

Book: Enhancing High-Volume Comparable Sales Processing with Regression Models

Link to the Kindle version

Book Summary

In high-volume valuation environments, from mass appraisal to mortgage lending, the comparable sales process is often bogged down by subjective, manual methods. "Enhancing High-Volume Comparable Sales Processing with Regression Models" offers a solution that bridges the gap between traditional valuation and applied econometrics.

This book provides a hands-on, two-pass regression modeling framework that streamlines and standardizes your workflow. You'll learn how to build robust baseline models using foundational variables like location, time, and living area, and then refine them by adding conditional variables that meet a high bar for statistical significance.

We demonstrate how to use real-world data from diverse markets and property types, explaining powerful, often misunderstood techniques such as dummy, effects, one-hot, and custom deviation coding. You'll learn how to accurately account for time, identify and remove outliers, and evaluate your models' performance using both statistical and sales ratio metrics. You will learn to use ordinal encoding to manage hierarchical categorical variables, such as property condition or quality ratings, as these can be ranked in a logical sequence.

The result is a transparent and defensible valuation grid that converts model coefficients into precise, data-driven adjustments. By making your models more econometric, you can produce consistent, credible valuations at scale, making your work more efficient and professional. This book is a must-have for anyone looking to replace manual guesswork with a rigorous, repeatable process.

Friday, June 13, 2025

Pitfalls of Overusing Micro-Location Variables in AVM & CAMA Modeling: Embracing Ridge Regression as a Reliable Solution

In the rapidly evolving world of property valuation, Automated Valuation Models (AVMs) and Computer-Assisted Mass Appraisal (CAMA) systems have become indispensable tools. They promise unparalleled efficiency, scalability, and data-driven insights for everything from mortgage lending and homeowners' insurance to equitable property taxation. At the heart of these models lies the power of data and, increasingly, the allure of "micro-location variables"—also known as geographic information system (GIS) variables, location surface variables, or response surface variables. These “on-the-fly” proxies aim to capture the subtle, hyper-local nuances that can significantly impact property value, from proximity to a bustling café to the precise angle of a mountain view.

However, this very granularity presents a formidable challenge. When in-house technicians or external consultants develop and deploy a multitude of these micro-location variables without rigorous statistical discipline, they inadvertently pave the way for models that are misleading, unstable, and, ultimately, unreliable.

This blog post will delve into the critical pitfalls of such unconstrained use, exposing how overreliance on untested micro-location variables can lead to a fundamental lack of sample representativeness, rampant multicollinearity, and a significant loss of model interpretability. The post will also explore the specific dangers this poses for institutional users who are paying top dollar for accurate, robust, and defensible valuations, arguing that an uncritical acceptance of such models carries substantial financial and reputational risks.

The Pitfalls of Overusing Micro-Location Variables: A Deeper Dive

The over-reliance on "on-the-fly" micro-location variables in AVM and CAMA models presents significant risks that institutional users must carefully consider. While these variables can offer granular insights, their unconstrained use, particularly with standard linear regression, can severely compromise the model's reliability, interpretability, and long-term validity.

Here's an elaboration on the pitfalls and a compelling case for caution for institutional users:

1.  Loss of Representativeness: Over-reliance on micro-location variables in AVM and CAMA models can result in models that are too specific to the sales sample used in the modeling process. When models are heavily dependent on sales samples using numerous micro-location surface variables, they can become "overfitted" to that specific sample. While these models may achieve impressive statistics, such as high R-squared values and low coefficient of dispersion (COD), within the modeling sample, this precision is often an illusion when applied to the broader property population. In other words, this lack of generalizability or representativeness can lead to distorted property values in areas where the variables do not accurately reflect the broader population.

2.  Multicollinearity Issues: The excessive use of micro-location variables can exacerbate multicollinearity problems within the model, leading to unreliable estimates and inflated model performance metrics, such as R-squared and COD, which can mask the underlying issues. Ignoring multicollinearity can result in misleading conclusions and inaccurate predictions. Micro-location variables, by their very nature, often exhibit high correlations with one another and with fundamental property characteristics; for instance, a "proximity to park" variable might correlate strongly with a "neighborhood amenities score." When these variables are highly correlated (multicollinear), they convey redundant information to the model, which can lead to inaccurate predictions.

3.  Confounding Baseline Variables: When micro-location variables overshadow essential baseline variables, such as land and building sizes, age, construction quality, and other pertinent characteristics, the model may lose robustness and predictive accuracy. Neglecting these foundational variables in favor of micro-location variables can compromise the model's overall integrity. The conflict with baseline variables is particularly problematic because they are the fundamental drivers of property value. If highly correlated micro-location variables are "stealing" explanatory power from these baseline variables, the model's fundamental logic is compromised. It may attribute value to a micro-location feature driven by, for example, the underlying quality of the school district, leading to misattribution and a flawed understanding of market dynamics.

4.  Model Interpretability: Models that heavily rely on micro-location variables may become overly complex and difficult to interpret. Users may struggle to understand the underlying relationships between variables and may not be able to explain the rationale behind the model's predictions. This lack of transparency can erode trust in the model's outputs. However, by selecting micro-location variables that provide unique explanatory power and are not highly correlated with existing variables (or each other), technicians can ensure that the model remains stable and interpretable. Similarly, users can better understand the impact of these variables on the predicted values, increasing confidence in the model's outputs and facilitating more informed decision-making.

5.  Vulnerability to Changes: Micro-location variables are often subject to external changes such as urban development, zoning regulations, or environmental factors. Models heavily dependent on these variables may struggle to adapt to shifting conditions, leading to outdated or inaccurate property valuations. By including a select set of micro-location variables that have been rigorously tested for representativeness and multicollinearity, the model can be more flexible and adaptable to changing conditions. These variables can enable the model to adapt to evolving market dynamics, regulatory changes, or other external factors that may influence property valuations.

Institutional users of AVM and CAMA models, whether for lending, portfolio management, risk assessment, or appraisal, have a fiduciary responsibility to rely on robust, transparent, and reliable valuation methodologies. The uncritical acceptance of models over-reliant on "on-the-fly" micro-location variables directly undermines this responsibility.

In conclusion, while micro-location variables can provide valuable insights when used judiciously, institutional users must demand a balanced approach to their use. They should prioritize models that robustly incorporate fundamental property characteristics while employing micro-location-based data as a supportive, rather than dominant, input. Thorough validation processes, independent reviews, and a deep understanding of the model's underlying assumptions are essential to safeguard against the significant pitfalls of over-relying on "on-the-fly" micro-location variables in AVM and CAMA modeling. The goal should be to build models that are accurate, representative, generalizable, interpretable, and resilient to market changes, not just models that produce high but potentially misleading performance metrics in a limited context.

Implementing Limited Micro-Locations Judiciously

While the unbridled use of "on-the-fly" micro-location variables can destabilize AVM and CAMA models, their strategic and constrained application offers a significant opportunity to enhance valuation accuracy, efficiency, robustness, and reliability. When carefully developed and rigorously tested for relevance, representativeness, and multicollinearity, a limited number of these variables can act as powerful complements to broader, more stable location proxies, such as tax assessor-defined or AVM technician-developed fixed neighborhoods or even (repurposed) Census Tracts. This intelligent integration allows institutional users to gain a more granular understanding of value drivers without succumbing to the pitfalls of overfitting and multicollinearity.

1.  Complementing Fixed Neighborhood Characteristics: By incorporating micro-location variables that complement assessor-defined fixed neighborhoods or other fundamental location variables, the model can capture additional nuances and variations within specific geographical areas. These variables can provide valuable context and insights that may not be captured by broader neighborhood definitions, enabling more precise property valuations.

2.  Improving Predictive Performance: Selecting micro-location variables that are relevant and non-redundant can improve the model's predictive performance. These variables can capture critical geographic features, trends, or patterns that influence property values, leading to more accurate and reliable predictions.

3.  Enhancing Model Interpretability: A limited number of carefully chosen micro-location variables can make the model more interpretable and transparent. Users can gain a better understanding of how these variables affect the predicted values, leading to greater confidence in the model's outputs and facilitating more informed decision-making.

4.  Flexibility and Adaptability: By incorporating a select set of micro-location variables that have been rigorously tested for multicollinearity, the model becomes more flexible and adaptable to changing conditions. These variables enable the model to adapt to evolving market dynamics, regulatory changes, or other external factors that may influence property valuations.

5.  Efficient Use of Resources: Focusing on a limited number of micro-location variables that complement existing location variables can optimize the use of resources and computational power. By streamlining the model with relevant and impactful variables, users can avoid unnecessary complexity and improve the overall efficiency of the modeling process.

In conclusion, integrating a constrained set of micro-location variables that have been thoroughly evaluated for their relevance, representativeness, and lack of multicollinearity can significantly enhance the efficiency, robustness, and reliability of AVM and CAMA models. By strategically incorporating these variables to complement existing location data, institutional users can leverage the distinctive advantages of micro-location information while mitigating the potential pitfalls associated with overuse. This approach not only improves the model's performance but also instills confidence in users regarding the accuracy and consistency of the valuations provided, ultimately enhancing the overall effectiveness of valuation processes.

A Few Examples

Identifying effective, limited micro-location variables requires a deep understanding of local market dynamics combined with rigorous statistical discipline. The goal is to capture significant, granular value drivers that are not adequately explained by broader location proxies while ensuring they are representative of sufficient sales activity and do not introduce problematic multicollinearity.

1.  Distance to Amenities: Incorporating distance variables, such as proximity to schools, parks, public transportation, shopping centers, and recreational facilities, can provide valuable insights into the property's desirability and convenience. These variables, when carefully selected and validated for relevance, can enhance the model's predictive power without introducing issues of multicollinearity. By capturing the influence of nearby amenities on property values, these variables can improve the accuracy and efficiency of valuation models.

2.  Neighborhood Socioeconomic Indicators: Including neighborhood-level socioeconomic indicators, such as median income, educational attainment, crime rates, and employment levels, can offer valuable context for property valuation. These micro-location variables can provide additional layers of information about the neighborhood's economic status and livability, complementing the traditional location data used in AVM and CAMA models. By ensuring that these variables are representative of the sample and do not introduce multicollinearity, users can enhance the model's robustness and reliability.

3. Environmental Factors: Accounting for environmental variables, such as air quality, proximity to green spaces, flood risk, and noise levels, can be instrumental in assessing property values. These micro-location variables, when judiciously integrated into the model, can provide insights into the area's environmental quality and its impact on property prices. By carefully selecting environmental variables that align with the sample's representativeness and ensuring they do not lead to multicollinearity, technicians can improve the model's efficiency and accuracy in predicting property values.

4.  Market Trends and Demographic Changes: Including micro-location variables that capture market trends, demographic changes, and development activities in the area can further enhance the model's predictive capabilities. Variables such as population growth rates, housing market saturation levels, and commercial development projects can provide valuable real-time insights into local market dynamics. By incorporating these variables in a limited and strategic manner, technicians can improve the model's reliability and adaptability to changing market conditions while maintaining sample representativeness and avoiding multicollinearity.

Incorporating these examples of effective, limited micro-location variables into AVM and CAMA models can yield valuable insights and enhance the models' overall efficiency, robustness, and reliability. By carefully selecting and validating these variables to ensure they enhance the model's predictive power without compromising its integrity, technicians can leverage the unique benefits of micro-location information while addressing key challenges related to sample representativeness and multicollinearity.

Ridge Regression to the Rescue

When technicians insist on creating and incorporating a multitude of micro-location variables on the fly without adequately addressing multicollinearity and representativeness, they must consider alternative regression methods to mitigate these challenges. One such specialized regression technique is Ridge Regression, which offers distinct advantages over standard linear regression methods, such as Ordinary Least Squares (OLS). Here's a compelling case for why technicians should leverage Ridge Regression when using a large number of micro-location variables in their models:

1.  Multicollinearity Management: Ridge Regression is particularly effective in addressing multicollinearity, a common issue when dealing with a large number of correlated predictors. By penalizing coefficient magnitudes and shrinking them toward zero, Ridge Regression helps stabilize parameter estimates, reducing the impact of multicollinearity on model results. Technicians using multiple micro-location variables can benefit from Ridge Regression's ability to handle high collinearity, thereby improving the stability and reliability of coefficient estimates.

2.  Model Generalization: Ridge Regression helps improve the model's generalizability by controlling the variance of parameter estimates. When technicians create micro-location variables on the fly, there is a risk of overfitting the model to the modeling data, leading to reduced performance on new datasets. Ridge Regression's regularization technique helps prevent overfitting and enhances the model's ability to generalize well to unseen data, making it a more robust choice for complex models with numerous variables.

3.  Improved Predictive Accuracy: By incorporating Ridge Regression in the modeling process, technicians can enhance the predictive accuracy of the model, even when using a large number of micro-location variables. The regularization properties of Ridge Regression help prevent the model from becoming overly sensitive to noise in the data, leading to more reliable predictions and reducing the likelihood of spurious relationships between variables, thus instilling greater confidence in institutional users regarding the model's ability to provide accurate and stable property valuations.

4. Transparency and Trust: Leveraging Ridge Regression demonstrates a commitment to utilizing advanced statistical methods to address the challenges associated with complex modeling scenarios. By implementing a technique specifically designed to address multicollinearity and improve model performance, technicians can demonstrate their commitment to producing trustworthy, transparent results, which, in turn, can enhance the credibility of the model's outputs and reassure institutional users of the reliability of the valuation process.

In conclusion, technicians who insist on using multiple micro-location variables in their models should prioritize adopting specialized regression methods, such as Ridge Regression, to mitigate multicollinearity and enhance the model's efficiency, robustness, and reliability. By demonstrating a proactive approach to managing complex variables and incorporating advanced statistical techniques, technicians can foster trust and confidence among institutional users, ultimately strengthening the validity and accuracy of the valuation outcomes.

Conclusion

The journey through the intricate world of micro-location variables reveals an apparent dichotomy: while they hold immense potential to refine AVM and CAMA models, their indiscriminate, unconstrained use poses significant threats to the integrity of these models and their real-world applicability. This blog post has highlighted how an over-reliance on a multitude of "on-the-fly" micro-location variables can lead to models that lack generalizability, are plagued by multicollinearity, obscure fundamental property characteristics, become black boxes, and are highly vulnerable to external changes. These are not merely academic concerns; they translate directly into unreliable property values that can undermine lending decisions, misguide investments, and erode public trust in the fairness of assessments.

Therefore, this discussion serves as a dual call to action.

For in-house technicians and external consultants tasked with building these sophisticated models, it is imperative to embrace statistical rigor, which entails prioritizing careful variable selection, insisting on robust representativeness and multicollinearity tests, and recognizing that less can often be more. When a multitude of micro-location variables cannot be avoided, responsible practitioners must turn to specialized regression methods, such as Ridge Regression. While not a panacea, this approach can at least mitigate the devastating effects of multicollinearity inherent in such complex sets of variables.

For institutional users—the discerning consumers of AVM and CAMA outputs who are investing heavily in these services—this requires diligence, not simply accepting models because they claim high R-squared values and low CODs. Instead, they must demand transparency, challenge the methodology, inquire about the validation processes for micro-location variables, and understand the trade-offs involved, insisting on models that are not only accurate but also robust, reliable, and interpretable.

Fostering a culture of informed scrutiny and responsible model development can collectively ensure that automated valuation models truly serve as powerful, trustworthy tools rather than introducing hidden risks into the very foundations of the property market.

Sid's Bookshelf: Elevate Your Personal and Business Potential

Thursday, November 28, 2024

Sid's Bookshelf: Elevate Your Personal and Business Potential

 Note: These books are also available on Amazon in Paperback and Hardcover versions. 

28. The Quantitative Country Analyst: A Data-Driven Guide to Global Mobility

                                 PDF Version

                                    Kindle Version

27. The Nomad's Compass: A Data-Driven Guide to Global Retirement and Investment

                             PDF Version        

                             Kindle Version

26. The Pensionado Path: A Comprehensive Exploratory Guide to Affordable Retirement in Latin America

                               PDF Version

                                 Kindle Version

25. Tax Justice: A Blueprint for Replacing Property Taxes with Middle-Class-Friendly Reforms

                                 PDF Version

                                 Kindle Version

24. Revolutionizing Property Tax Assessment: Navigating a Shifting Real Estate Market in the Era of Declining Commercial Tax Revenue

                                  Kindle Version

                                  PDF Version

23. The Art and Science of Comparable Sales Analysis in Property Valuation

                    Kindle Version

                                PDF Version

22. Mastering Mass Appraisal Modeling: A Hands-On Guide with Real-World Data

                        Kindle Version

                          PDF Version

21. From Basics to Breakthroughs: A Beginner's Journey in Data Analysis and Modeling in Excel

                          Kindle Version

                             PDF Version

20. A Beginner’s Guide to Automated Valuation Modeling (AVM): Step-by-Step Demonstration of Model Development with Real-World Data and Numerous Illustrations

                      Kindle Version

                        PDF Version

19. A Beginner's Guide to Hands-on Statistical Analysis and Modeling in Excel with Housing Case Studies

                   Kindle Version

                     PDF Version

18. Bailing out the Dysfunctional US Property Tax System

            Kindle Version

                    PDF Version

17B.  Revolutionizing Resale: An AI-Assisted Guide to Tesla Model Y Market Trends for Consumers and Industry Analysts

                Kindle Version

                PDF Version

17A. Data-Driven Decisions: Unlocking the Tesla Model 3 Resale Market and Buying Strategies with AI

               Kindle Version

               PDF Version

 16. The AI Advantage: Strategic Retirement Planning for New Professionals 

         Kindle Version

             PDF Version

15. From Stay-at-Home to Successful Entrepreneurs: AI-Assisted Property Assessment Appeals

             Kindle Version            

             PDF Version

14. Mastering Assessment Ratio Challenges: A Comprehensive AI-Enhanced Guide for Appraisers and Property Tax Professionals

         Kindle Version               

              PDF Version

13. AI-Assisted Property Assessment Appeals: A Comprehensive Guide to Winning Your Case and Reducing Property Taxes with Advanced Strategies

            Kindle Version

            PDF Version

12. Automated Valuation Modeling (AVM) Made Easy: A Beginner's Guide with Interactive AI Chatbot ChatGPT and Real-World Data

            Kindle Version

            PDF Version

11. AI-Curated Wedding Menus: A Comprehensive Guide to Menu Planning and Cost Management

            Kindle Version

            PDF Version

10. The AI Revolution: Reshaping the Future of Work

            Kindle Version

            PDF Version

9. AI Revolutionizing Real Estate: Exploring Case Shiller Index for Smart Predictions

            Kindle Version

            PDF Version

8. AI Investing 101: A Comprehensive Guide for New Investors in the Stock Market

            Kindle Version

            PDF Version

7. Revolutionizing Data Analysis and Modeling with AI: A Hands-On Guide

            Kindle Version

            PDF Version

6. AI Unleashed: Mastering the Art of Investing in Magnificent Seven Bellwether Stocks

            Kindle Version

            PDF Version

5. Mastering the Stock Market with AI: Advanced Analysis and Strategic Techniques

            Kindle Version

            PDF Version

4. The Conversational AI Revolution: How ChatGPT and Bard Are Changing the Way We Communicate

            Kindle Version

            PDF Version

3. The Future of Housing: A Guide to AI-Powered Real Estate Solutions

            Kindle Version

            PDF Version

2. How to Use AI Chatbot Bard to Master Data Analysis and Modeling

            Kindle Version

            PDF Version

1. Conversations with ChatGPT: Exploring the Future of Humanity (Updated 2.0 is available)

            Kindle Version 

            PDF Version


Holdout Testing – Validating Model Stability and Residual Independence

Session 8 of the Mass Appraisal Modeling series is now live. In one-step CAMA environments, the finished model writes Just Values directly...