• Welcome to AppraisersForum.com, the premier online  community for the discussion of real estate appraisal. Register a free account to be able to post and unlock additional forums and features.

Linear Regression

Status
Not open for further replies.
Software is great. Typically, unless one knows how to do the calculations such software is mostly useless. What you need is the fundamental knowledge. Once you have that you're good to go. Visit your local library and pick up a statistics book. After you've read that a couple of times you should be ready to utilize the software.

Actually, Fall semester registration is occuring right now for most junior colleges. A one night a week math class would probably be the best way to learn the basics of this kind of statistical/graphical math.

I'm fixing to sign up to take a GIS class. I think that will be a good tool for establishing the kind of appraisal practice I'm thinking of.
 
Look at the grid on a 1004 form for the answer to your question. A friend of mine uses excel for regression analysis. I still do it the old fashioned way...I guess.
 
Actually, Fall semester registration is occuring right now for most junior colleges. A one night a week math class would probably be the best way to learn the basics of this kind of statistical/graphical math.

I'm fixing to sign up to take a GIS class. I think that will be a good tool for establishing the kind of appraisal practice I'm thinking of.

"Fixing to...."?!? Fixing? From California? Better sign up for one of them English courses. *Joking* I'm from the south. I have lived in the south all my life and we are never about to do anything. We're always fix'in to do something.
 
There are some people on this forum that think using regression is a great thing. It can be IF you really understand how it works. It looks easy but there are many pitfalls. Ya ya I know I'll hear from some of the proponents who like to ignore the underlying assumption of regression. There have been several other threads here where that horse has been beaten and is still dead. As others have said you really must study (assuming you're mathematically literate a reading book might do it. If not you should take a real course not just some one day course for appraiseres) before putting your reputation on the line. I recently acted as an expert witness where an appraisers used regression. His client lost big time and the appraiser slinked out of court.
 
There are some people on this forum that think using regression is a great thing. It can be IF you really understand how it works. It looks easy but there are many pitfalls. Ya ya I know I'll hear from some of the proponents who like to ignore the underlying assumption of regression. There have been several other threads here where that horse has been beaten and is still dead. As others have said you really must study (assuming you're mathematically literate a reading book might do it. If not you should take a real course not just some one day course for appraiseres) before putting your reputation on the line. I recently acted as an expert witness where an appraisers used regression. His client lost big time and the appraiser slinked out of court.
FWIW,
I agree with much of this. Debating on this forum has taught me that many people should not incorporate computerized regression tools into their work - and real estate appraisers may well be a significant part of that group. That may change, as the new requirements include a semester of statistics and a course in modeling.

I cannot say that I am a "proponent" of regression. However, I can say it would be very difficult for any adult to get through a day without making a decision that used regression analysis, and even more difficult to get through real estate appraisals without using it one way or another. In my opinion, appraising without computerized regression tools is like eating broth with a fork.

As to the "assumption" CB, I just once like to see an example of regression gone bad that was not pilot error, but error caused by using a slighly better formula than one can use counting on fingers.
 
FWIW,
I agree with much of this. Debating on this forum has taught me that many people should not incorporate computerized regression tools into their work - and real estate appraisers may well be a significant part of that group. That may change, as the new requirements include a semester of statistics and a course in modeling.

I cannot say that I am a "proponent" of regression. However, I can say it would be very difficult for any adult to get through a day without making a decision that used regression analysis, and even more difficult to get through real estate appraisals without using it one way or another. In my opinion, appraising without computerized regression tools is like eating broth with a fork.

As to the "assumption" CB, I just once like to see an example of regression gone bad that was not pilot error, but error caused by using a slighly better formula than one can use counting on fingers.

Software developers ask this question "What percent of appraisers can really use (1) Linear, (2) Multi-Linear and (3) Other more advanced forms of regression, such as MARS (Multiple Adaptive Regression Splines). Nobody really knows. It could be less than 1% - based on posts we find on the forums. This creates an enormous risk to doing this kind of software development - because you also have to think about training and support issues. If there hadn't been a downturn in the market, we would probably see more regression tools around. As it is, things are not too hopeful - development has been cut back in many areas. The Excel tools out there are very weak.

For those few statistically advanced residential appraisers - they will just have to get by with Excel macros and non-appraisal related tools for the time being. .... But I can tell you that there are some juicy C#/.NET prototypes around - but no way to fund them to perfection, i.e. production.

Bert Craytor, SRA
 
Bert,
I am just not sure how much I would go along with these things being “advanced.” I find much appraisal literature lacks even a fundamental understanding of arithmetic to the point that inverse operations are portrayed as separate “approaches” and “methods” that only varied in the report because of rounding error – replete with extensive explanations based on appraisal and economic theories attempting to “reconcile” the differences in the final reconciliation section of the report.

A second and related factor, for me, is recognizing how little we have to scratch surface of deep bodies of knowledge. Just because we have to figure out square footage of triangular areas, doesn’t mean we have to be full-fledged geometricians, reciting Euclid. Same thing with regression. We are just using a few mathematical tools that are also used by others.

Understanding these techniques is more a matter of simple vision and basic theory rather than profound knowledge. Maybe my viewpoint is tempered because when I first figure these things out, I had to do it with pencil and paper. It’s easy for anyone to understand if you pair two sales that you look at the change of price between them, and then change of square feet, and even just divide in your head to get something like $30/sf. If one does “regression” by hand, one sees that it is just summing all the prices and summing all the square feet (and some squaring and cross-multiplying, yada-yada), and its just comparing them all at once, instead of one pair at a time, and that it works better because the pairs don’t have to be “perfectly matched.” To me, the basic regression formula is just a better formula than the one used for perfectly matched pairs, because it works when the pairs are not perfectly matched (which they never are).
 
It can only get better.

I am just not sure how much I would go along with these things being “advanced.” I find much appraisal literature lacks even a fundamental understanding of arithmetic to the point that inverse operations are portrayed as separate “approaches” and “methods” that only varied in the report because of rounding error – replete with extensive explanations based on appraisal and economic theories attempting to “reconcile” the differences in the final reconciliation section of the report.
Sad, but true. :new_all_coholic:
 
Bert,
I am just not sure how much I would go along with these things being “advanced.” I find much appraisal literature lacks even a fundamental understanding of arithmetic to the point that inverse operations are portrayed as separate “approaches” and “methods” that only varied in the report because of rounding error – replete with extensive explanations based on appraisal and economic theories attempting to “reconcile” the differences in the final reconciliation section of the report.

A second and related factor, for me, is recognizing how little we have to scratch surface of deep bodies of knowledge. Just because we have to figure out square footage of triangular areas, doesn’t mean we have to be full-fledged geometricians, reciting Euclid. Same thing with regression. We are just using a few mathematical tools that are also used by others.

Understanding these techniques is more a matter of simple vision and basic theory rather than profound knowledge. Maybe my viewpoint is tempered because when I first figure these things out, I had to do it with pencil and paper. It’s easy for anyone to understand if you pair two sales that you look at the change of price between them, and then change of square feet, and even just divide in your head to get something like $30/sf. If one does “regression” by hand, one sees that it is just summing all the prices and summing all the square feet (and some squaring and cross-multiplying, yada-yada), and its just comparing them all at once, instead of one pair at a time, and that it works better because the pairs don’t have to be “perfectly matched.” To me, the basic regression formula is just a better formula than the one used for perfectly matched pairs, because it works when the pairs are not perfectly matched (which they never are).

Steven,

1. The adjective "advanced" is in relation to appraiser knowledge. However, Multiple Adaptive Regression Splines, or more generally, "Generalized Additive Models" are actually one of the more "advanced" areas in statistics - even for statisticians - as many of the algorithms have only matured in the last decade. Some of the original works are "Generalized Additive Models" b T.J. Hastie & R.J. Tibshirani, 1990,(Stanford), "Classification & Regression Trees" by L. Breiman & J.H. Friedman, 1984( UC Berkeley & Stanford).

2. "Understanding the techniques" probably is not as important as understanding the nature of what they are applied to. If you don't believe me, see how far you get reading the two above books!

The best example is GLA, which is almost always the primary VARIABLE factor in contributory value (the major factor being base site value in California). A regression model may kick out a value of $300/sf. In fact, I have models of condos where the value is $1000/sf and high end homes with values of $800/sf. The "technique" does not understand what that means. However, the appraiser has to often have a very good, fundamental, in-depth understanding of the contributory value of various components of a property to put that kind of contributory value in its proper place - and possibly adjust it. This is a subject that takes some time to get into - and I won't try to do it here. Suffice it to say that in my opinion, the percentage of appraisers who could competently deal with this are those with good quality college degrees or who in any case could make it into Mensa or get at least 650 on the math portion of the SAT (and that doesn't guarantee anything of course ... because I know people that have advanced degrees, but have long since forgotten everything related to advanced math and science that they learned when they were young through disuse [very common ... I should know]).

The point here is that it is probably not profitable for a software company to come out with a product that supports regression to any degree. TRAINING would be a major expense. Would appraisers shell out the necessary $$$ for ADEQUATE training?

I am sure that current software products will slowly and incrementally be introduced as minor improvements in existing software ... but the appraisal software companies will be continually testing the market to see if what they are doing is profitable.

The other approach is that, that Snapwire is kind of taking... build a product (theirs is for commercial appraisal) that can, to a greater or lesser extent, work for other markets. That's because valuation sucks as a business. You've really got just one major group (Argus/SnapWire) that takes a majority of the commercial valuation business. Argus has actually has a near monopoly on DCF related products.

Other areas somewhat related to Valuation are far more profitable. For example, look at Pricing software - you see a much different story. (Noting that Pricing should have something to do with Valuation - but is in fact in a completely different ballbark.)

Bert Craytor, SRA
 
Last edited:
Two good titles on regression from the Institute.

Practical Applications in Appraisal Valuation Modeling

A guide to Appraisal Valuation Modeling

**********************
 
Status
Not open for further replies.
Find a Real Estate Appraiser - Enter Zip Code

Copyright © 2000-, AppraisersForum.com, All Rights Reserved
AppraisersForum.com is proudly hosted by the folks at
AppraiserSites.com
Back
Top