Cracking the Zillow Code


Lee Ovington of Valuation411 takes a crack at dissecting the Zillow valuation process. Also read the comment by David Gibbons of Zillow, where he sheds some additional light on the algorithms used.

Ovington writes, “Quite simply, the Zestimate relies on a calculated relationship of assessed value to sale price. Zillow merely takes selected transactions and calculates the relationship between the Assessed Values and the Sales Prices. It then applies that ratio to the subject’s assessed value (plus or minus some adjustments) and “whala”, you have Zestimate!”

Gibbons explains, “… the reason you measure a strong correlation between tax assessed values and Zestimates is not because our algorithm is simplistic but because the data we have is incomplete in your area… we’re missing the other information we typically get from the assessor, like sq. ft. and # of beds and baths. In cases like this, no other data is considered in the Zestimate – not becasue the algorithm is flawed – but because we don’t yet have the info.”

He continues, “When we do have more information, we use it. The last time I saw a correlation coefficient for all of our data fields, the most correlated field was actually “finished sq. ft.”. Our algorithm mashes up multiple valuation approaches. This allows us to both produce fairly accurate Zestimates with little data but also to significantly tighten up Zestimates when there is more data to be considered.”

One of the interesting parts of the post is where he talks about defending his appraisal to a homeowner who wants to believe the value they found on Zillow and why the appraisal would/could come in lower.

This is something that is starting to happen, and will happen more and more as the public becomes more aware of Zillow and as Zillow improves their valuation processes.


2 thoughts on “Cracking the Zillow Code

  1. The absence of critical data like beds, baths, sq.ft., should result in a zestimate along these lines “How the heck are we supposed to know. If and when we get more data (owner are you listening) we’ll put up a zestimate. Until then, here’s what the local assessor says is its FMV ”
    Zillow would garner my respect for this kind of honesty.
    But to boldly post a value to the dollar (what’s the psychological underpinning with that?) between an absurdly large range, give the monthly change & plot the property like a stock in such a case is disingenuous at best. See exampe below:

    No AVM makes house calls. Your home has to be seen to be valued. As Zillow says, it’s “a” starting point not the “best” starting point or even a “good” starting point. When you’re ready to get down to business, get a few CMAs from local realtors or pay for an appraisal. Just don’t hit the bricks with a zestimate tucked under your arm.

    BTW, Electronic Appraiser out of Florida (since 1995) bested several AVMs, including zillow on an MSN MOney test.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s