Appraising with Regression


WRE, Working RE Magazine, Appraiser News, Appraiser Magazine, Real Estate Appraisers, Volume 35
>> See Past News Editions
>> Click to Print
Recently Updated
2015 Expert’s Guide to Defensible Workfile

“Bulletproof” your Workfile
protect your license and your livelihood with expert help. Quick tips from an expert on how to produce highly defensible reports that keep you safe and raise the quality of your product. Click now

Recently Updated

2015 AMC Guide
UPDATED 2015 AMC Guide. Increase orders so you can turn down low-fee AMC work, negotiate fees from a position of strength and confidence and refuse to work for the AMCs that undervalue you. Start 2015 off with a new book of clients! Work with the best and fire the rest. Click now.












> FREE Webinar in April (Reserve space now!)
Background Checks- Understanding the Problem, Finding a Solution

Editor’s Note: In life after Collateral Underwriter (CU), appraisers are eager to understand how they can create statistical support for their adjustments and value results. In this story, author James Swartz provides a good primer for understanding regression and appraising.

Appraising with Regression
By James A Swartz, PhD.

As a real estate appraiser, you are interested in determining how a set of characteristics such as the number of baths and bedrooms, total s As a real estate appraiser, you are interested in determining how a set of characteristics such as the number of baths and bedrooms, total square feet, and others, affects the value of a property.

Property characteristics that affect value are called independent or predictor variables because they help predict what the property is worth. An estimated sales price is called the dependent variable because it depends on the predictor variables.

One statistical tool used to estimate value is called regression analysis. Regression techniques have long been central to the field of economic statistics (“econometrics”). Increasingly, they have become important tools for appraisers as well.

In an appraisal regression model, the dependent variable or sales price is “regressed” on a set of property characteristics to determine how much of the variation in the sales prices, of geographically comparable properties, are due to the variation in the set of property characteristics. The higher the percentage of variation in the sales prices of like properties that can be “explained” by the included set of property characteristics, the more accurate the prediction of the property value. A thorough regression analysis will therefore improve your ability to accurately appraise property values beyond what can be done by “guestimating” or looking at only one or a few property characteristics and comparing only a few similar properties.

The best way to begin to understand how regression modeling works in the context of property appraisal is to explain the approaches used and then walk through an example.

Regression Modeling Approaches
Let’s begin by analyzing a few different methods of regression analysis. Simple linear regression, also called Bivariate regression, assesses the relationship or association between a single dependent variable, such as a sales price, and a single independent or predictor variable, such as square footage.

Multiple linear regression assesses the relationship or association between a single dependent variable, such as sales price, and multiple independent or predictor variables, such as square footage, lot size and age of the property.

(story continues below)

(story continues)

Hedonic regression is an even higher level of analysis because it can be used to estimate the contributory value of each property characteristic on an estimated property value. There are four steps in the process:

First, a group of properties in geographic proximity to the subject is selected from the MLS database. The number of properties selected for analysis should be large enough (no fewer than 200 properties) to allow for the examination of the variation in property characteristics as well as in sales prices. Greater variation in the characteristics studied is desired, rather than a narrow comp selection based on strict comparability, because greater variation improves the accuracy of the estimated effects on sales price for each characteristic across a broader range of possible values for that characteristic.

Then, a set of simple regression models is run using the selected properties. A separate simple or Bivariate regression (i.e., two-variable) is run for each property characteristic. Each simple regression is run on the full data set containing information on the 200+ properties. The purpose of this step is to screen for those property characteristics that can be reliably associated with variations in the sales prices of the properties in the data set.

In the third step of the process, those property characteristics that are found to be reliably associated (i.e., statistically significant) with the sales prices of properties, are included in a multivariable regression model (i.e., many variables). Using the full data set, the multivariable regression assesses the association between sales price, the single dependent variable, and a set of multiple predictors such as square footage, lot size, and age of the property.

This model determines how well the remaining property characteristics individually and as a set predict variation in sales prices. Importantly, the model examines the associations among the property characteristics themselves. Only those characteristics that uniquely predict sales price are retained in the model. Characteristics are dropped that overlap substantially with other characteristics already in the model. Only the best predictor set is retained.

In the fourth and final step, the appraiser selects a small subset (3) of properties comparable to the subject property. A map displaying properties by their proximity to the subject assists in this step. Using the predicted sales prices for these properties and the valuation for each property characteristic in the final multivariable model, a final value is obtained for the appraised property.

Overcoming Math Anxiety
People new to regression modeling often have questions about the technique and concerns about their ability to use and interpret the more complex but more accurate multivariable models. However, once a level of familiarity is developed and “math anxiety” is overcome, multivariable regression models become an indispensible tool for developing appraisals.

(story continues below)


(story continues)

Although simple or Bivariate linear regression models are appealing because of their simplicity, they will not produce as accurate a result as a multivariable regression analysis for a number of reasons. First, the selection of which variable(s) to use might leave out potentially important factors. Second, Bivariate regression does not control for the associations among the predictor variables themselves. For instance, the number of bedrooms and square footage might both have a very strong association with sale price when considered independently in separate Bivariate models. When considered simultaneously in a multivariable model, the association of the number of bedrooms with sales price might not be as substantial relative to the association with square footage.

Multivariable models will automatically adjust for the interdependency of these two (or more) predictors while Bivariate models will not. As a consequence, if you use two Bivariate models to develop your estimate, you would overestimate the sale price because you would be giving too much weight to the number of bedrooms within the context of the property’s square footage. The degree of error introduced by adding together the results of Bivariate models increases as you consider more and more predictors. In the end, it is much easier to use a multivariable model to make the correct adjustments and estimate a value without having to do all of the tedious mental and mathematical work of combining separate estimates.

Remember, regression analysis is not a substitute for traditional appraisal practices as much as it is a complement to your experience and judgment. It will help you identify the most salient features for estimating the value for a given property, possibly including some you might not have thought were important but which turn out to be, based on sales of other properties in the same area.

Upcoming Live Webinars – (details below)
April – Background Checks – Understanding the Problem, Finding a Solution – Presented by Comergence (Free)
May – Bulletproof Appraising: Fannie Mae, Due Diligence and Your State Board – Presented by Tim Andersen, MAI

Special: Free Webinar TOMORROW
Background Checks—Understanding the Problem, Finding a Solution
Are you tired of paying for background checks? Do you ever wonder WHY AMCs want background checks even though your state board already cleared you? In this webinar, Comergence Executive Corey Prezenkop explains the laws involved, where the requests are coming from, and how to simplify the process, save time and money, and avoid paying for background checks for multiple clients no matter how many AMCs that you work with. Time will be set aside to answer questions. Comergence is a  leading security and compliance firm. Sign Up Now!

Bulletproof Appraising: Fannie Mae, Due Diligence and Your State Board – (Two-Part Webinar)
Part 1: May 12th, 10 – 11:30 a.m. PST
Part 2: May 19th, 10 – 11:30 a.m. PST
Are you prepared to successfully defend your work against inquiries from Fannie Mae, your state board and your AMC/lender clients? Are you sure? This webinar is designed to share an expert’s knowledge of what it takes to protect yourself. Gained through years of defending appraisers before their state boards, over real-life reporting issues, USPAP expert Tim Andersen, MAI helps you fill in any experience or knowledge gaps in your practice so you can appraise confidently and successfully. Learn More / Sign Up Now!


About the Author
James Swartz, Ph.D. is an Associate Professor in the Jane Adams College of Social Work at the University of Illinois at Chicago. He obtained his Doctorate in clinical psychology from the Northwestern University Feinberg School of Medicine (1990) and also has a Masters degree in research methods and statistics from Loyola University of Chicago (1982). He has authored over 50 publications in peer-reviewed journals, the majority of which use advanced statistical analytic techniques.

Tags: ,

Comments (5)

  1. I think your description of the simple linear regression tactic was really fascinating. It’s interesting how focusing on the relationship and correlation between two variables in a sale. Thank you for such an informative article, I enjoyed learning about the appraisal process and how it can change when different tactics are applied.

    - Reply
  2. Background Checks: I think everyone is missing the main point with requiring background checks for appraisers. The real problem is that the appraiser provides personal & confidential information to some company ( business) that you know nothing about. What protection does the appraiser have that his or her information is protected? What happens when there is a breach of their computer system and my personal information is stolen or maybe one or more of their employees sell my information to some crooks? How do I know that this company that does my background check isn’t just a guy working out of his bedroom with a computer, has no liability insurance and therefore I have no recourse if he dose not protect my information. Also how do we know that the AMC’s are going to protect my information. I do not allow AMC’s to make direct deposits to may checking account, what assurance do I have that my account information on their system will not be hacked. If “Target”, “Home Depot”, Macy’s” and many other large businesses can’t protect my information what makes me trust some small company or AMC with my personal information.

    - Reply
  3. by

    Statistical analysis does not work anywhere. Sure, you can get 200 sales; however, most of them have nothing to do with the subject property. Even in the heyday of real estate, homes, commercial, etc. this was not a valid method of “enhancing” traditional methods. I will not be receiving this publication again.

    - Reply
  4. You say Regression works best with 200+ sales. I am in a rural country in TN with a total of 342 sales last year that went from vacant lots to acreage tracts, farmland, mountain land, vacant homes that needed to be torn down to multi-story lake homes and everywhere in between. Regression might work in Chicago, New York but I don’t see how in a rural market. Help me if you can.

    - Reply
    • Replying to Jack Hardy…I also am in a rural area. To run a meaningful regression, you go back five years in your MLS search. And you are going to put in search criteria for your MLS search just like when you search for comparables to exclude vacant land, that kind of thing. I love using multiple regression analysis as another tool. I use it as a sort of reasonableness test for adjustments. I run a regression for each of the neighborhoods where I work often and only update the data set every quarter or so. If you have 1,000 sales across five years, not much is going to change in your data set in a month, so just update now and then. You can save those regressions and refer to them as you work properties.

      - Reply

Leave a Reply

Your email address will not be published. Required fields are marked *