MAI Russell Roberts Commercial Real Estate Appraisals | Mississippi | Tennessee | Kentucky
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 my website for some other helpful analytical tools.
The MAI membership designation is held by professionals who can provide a wide range of services relating to all types of real property, such as providing opinions of value, evaluations, review, consulting and advice regarding investment decisions, among others. Property types may include commercial, industrial, agricultural, residential, vacant land and others.
I’ve been reading your posts on using simple regression and multiple linear regression with great interest. I’m an Excel geek at heart and I would love to play around with this to better understand it. Unfortunately the link to the spreadsheet isn’t working. I hate to be a bother, but would it be possible to get you to email me copy of this?
Hi Nick, have you gotten the spreadsheet? I’d really appreciate it if you could pass it on to me. Thanks!
Can you please send me the Excel Spreadsheet too ? Thanks
Have you gotten the spreadsheet? If so, I’d really appreciate it if you could pass it on to me.