Which comps to throw out
The median is sturdy and that sturdiness is a trap. An unlike sale can sit in the list, barely move the middle, and still be the wrong house. This page uses four invented prices so you can see the small median move and the large average move on the same set: $190,000, $198,000, $205,000, and $310,000. The $310,000 sale is the one to throw out, for reasons below. The dollars are not a closed sale.
What the four prices do to an average and a median
The average of all four is $190,000 plus $198,000 plus $205,000 plus $310,000, which is $903,000, divided by four, which is $225,750. Drop the $310,000 sale. The average of the three that remain is $593,000 divided by three, which is $197,666.67. The unlike sale lifted the average by $28,083.33. The plain median of the four, an even count, averages the two central prices. Sorted, those are $198,000 and $205,000. The average is $201,500. The median of the three is the middle one, $198,000. The unlike sale moved the median by $3,500. If your only check is “the median barely changed,” you will keep a sale that would have moved an average by $28,083. The median-versus-average guide is why the middle is the hand estimate. It is not permission to leave a bad sale in the list.
Reasons that are about the house, not the price
Throw the sale out when it is a different product. New construction against a house that needs a full scope. A different count of units. A busy road against an interior lot, if you are not adjusting for that and this formula does not adjust for it. A distress sale with a note you cannot explain, if the other three were ordinary retail sales. A different school zone when buyers in that market actually pay for the zone. None of those is “the price was high.” The price was high because the house was different. The count guide shows a $300,000 fourth sale pushing a central pair around. Same lesson, different list. Do not keep a sale to protect the count score. Five clean comps cap the count points. A sixth bad comp does not raise that cap and can still enter the median.
Do not throw a sale out only because it is the low one or only because it is the high one. On this list $190,000 is the low price and it stays, because the example says it matches. If the $190,000 house were the new construction and the $310,000 house were the renovated match to your subject, you would throw out the low one and the median of what remains would be a different conversation. Direction is not a reason. Match is the reason. Write the reason next to the price before you delete it, so you can audit yourself when the seller’s number is more flattering.
After the list is clean
With $190,000, $198,000, and $205,000 kept, the median is $198,000. An invented rehab of $34,000 makes the 70 percent offer $138,600 minus $34,000, which is $104,600. Type those three prices into the ARV and 70% rule calculator and leave $310,000 out. If you include it, the even median becomes $201,500 and the offer becomes $141,050 minus $34,000, which is $107,050. The $2,450 you just added to the offer came from a house you already decided was unlike. The MAO calculator will do the same 70 percent line from whatever ARV you hand it. It cannot see that you regretted the fourth price.
Bedroom adjustments are not a substitute for throwing a sale out. If the unlike feature is a bedroom count, the report can adjust dollars per bedroom and keep the sale. If the unlike feature is a new roof against a failed roof, there is no bedroom factor that fixes it. The bedroom and bathroom adjustment guide is the dollar rate and the gates. Use it for beds and baths. Use this page for everything that rate does not cover. A sale you adjusted and a sale you deleted are different acts. Do not do both for the same flaw.
The $3,500 median move is small next to a rehab contingency and large next to a wholesale fee you already spent an hour negotiating. Small is not the same as harmless. These four prices are invented so the $28,083.33 and the $3,500 can be checked by hand. They are not a farm of listings.
Questions
If the median barely moves, why throw the sale out?
On this list the median only moves from $198,000 to $201,500, but the average moves from about $197,667 to $225,750. If you or anyone else later averages the same list, the unlike sale is still in it. Throw it out before either calculation.
Does a lower price mean the comp is bad?
No. A lower price can be the best match. Throw a sale out because the house is a different product, not because you dislike the direction it pulls the number.
run a full analysis free when the median you can do by hand is not enough. A full analysis weights the comps, adjusts beds and baths, and prices the repair tiers. The sample figures there are invented, the same way every dollar on this page is invented.