AppraiserBench
Sign in Start free trial

Guides / Method

What paired sales analysis can prove

Paired sales is the method every reviewer asks for, and almost nobody has enough clean data to rely on it alone. Done carefully, it's the strongest evidence in the report. Two convenient sales don't prove much.

Summary

A matched pair tells you what two buyers paid for one difference. It's the strongest evidence you can put on the page, but it only covers one difference between two sales. Build pairs that differ in one thing, time-adjust before you compare, report the spread across your pairs instead of the average, and check the answer against a method that uses every sale you have.

What a pair proves

Two sales alike in everything but one feature. The price difference is what that feature was worth. The logic is simple, which is why every reviewer asks for paired sales and every textbook starts there.

It proves less than it usually gets asked to prove. A pair is two transactions. It carries the tastes, the financing and the bargaining of two buyers and two sellers on two days. Take a different pair from the same street and the answer moves, sometimes a little and often a lot.

That movement shows how much room there is around the number, and it belongs in the report. Averaging it away hides it.

Building a pair that differs in one thing

The method rests on "alike in everything but one." In residential work that's never quite true. The job is to get close enough that what's left over is small next to the thing you're measuring.

Two pairs don't give you a rate

One pair gives you a point. Two pairs give you two points, and then it's tempting to average them and call the rate derived. With two numbers you can't tell a tight answer from a loose one, and how loose it is turns out to be the part somebody challenges.

Report a range instead. Run as many pairs as the data supports, show the spread, and pick a number out of it for a stated reason. "Six pairs indicated between forty and seventy dollars per square foot. The four closest in age and condition fell between fifty and sixty. Fifty-five was selected." That's support. One averaged figure with nothing behind it claims a precision you didn't earn.

Sometimes the pairs scatter so far that no range means much. That's still a finding. It usually means the market doesn't price this feature consistently, or the pairs were less matched than they looked, or there are too few of them. Any of those beats a number chosen to fill in the cell.

You picked the pairs yourself

You chose the pairs, out of a set you assembled, to measure a variable you selected. That's three chances for your own judgment to shape the answer instead of the market. None of it shows up in the result, because a pair chosen to agree with you looks exactly like a pair that matches well.

Set the screening rules before you look at prices, so pairs aren't kept or dropped based on whether the answer suits. Then report the pairs you threw out and why.

Check it against a method that uses every sale

Paired sales uses a handful of transactions and ignores the rest. So pair it with something that uses the whole set and puts up with more noise in exchange for more observations. Grouped medians across the set, a regression on the variable in question, or a cost check where cost is a fair stand-in for what the feature contributes.

Neither method settles it alone. When the pairs and the wider analysis land close together, the conclusion is well supported and you can say so in a sentence. When they disagree, work out why. It usually points to a market split in two, a variable that moves with the one you're measuring, or a feature the market prices unevenly.

What goes in the exhibit

  1. The pairs, with both sales identified and the leftover differences named.
  2. The time adjustment applied to each, and the date it runs from.
  3. What each pair indicated, and the range across them.
  4. The second method and what it produced.
  5. The rate you selected, and why it sits where it does in the range.

That's one page. If you write it as you work, it takes a few minutes. Rebuilding it later can take an afternoon. See writing support a reviewer can follow.

Common questions

How many pairs are enough?

Enough that the range holds still when you add one or drop one. That depends on your data, so any fixed number quoted as a standard would be made up. If one pair moves the conclusion, the conclusion rests on that pair, and the report should say so.

Can I use listings to build pairs?

A listing is an asking price, not an agreement, and asking prices run high. Listings can bracket a conclusion or show which way the market is moving. They're weak as the main evidence for a rate, so if you use them, say that's what they are.

What if the only good pair is outside my comparable neighborhood?

A pair from a competing area can work if the two markets really are alike, and it's on you to show that rather than assume it. Usually a wider range from local sales is more defensible than a tight one borrowed from somewhere else.

CompAdjuster derives this from your comparables

Site, GLA, below grade, baths, garage and pool. Each rate is derived from the comps you selected, tested against paired sales, and written up in the commentary, with a report PDF and workfile to attach.