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.
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.