In a previous post I promised to provide a more in-depth explanation of using simple linear regression to adjust comparable sales. Today I will fulfill that promise. To do so, I will use an example of a size adjustment from a recent commercial appraisal I performed on an office building in Louisville, Kentucky. Appraisers have known for years … [Read more...]
Adjusting Comparable Sales Using Multiple Linear Regression Equation- Downloadable Spreadsheet
The most accurate method to derive adjustments applied to comparable sales is to perform a multiple linear regression on a large body of sales. The question then becomes "How can I use the equation to adjust my comparable sales?" Well, it took me some time to figure this out but here's a spreadsheet that does just that. Here's a link to a page on … [Read more...]
The