[DRM500RUBYZR-1]

Originally Posted by spork2367

A little statistical analysis shows that the market trend is still on a downward slope. If you believe that in general, mileage and condition go hand in hand (and they almost always do), you can come up with a formula that adjusts all the prices removing mileage(condition) as a variable to just look at the trend of average selling price over time. I did it based on two calculations. One using just the data from BAT sales and one assuming a 0 mile car is worth 60k and a 50,000 mile car is worth 17k.

When you adjust the BAT values based on the slope intercept formula derived from those graphs, you end up with a market trend graph for the sales adjusted for mileage. Both show a steady decline in average selling price. Which frankly, matches Hagerty's charts as well. The Hagerty trend shows average selling price dropping around 3k from 5/17 to 1/20. My derived data from the BAT sales shows a drop of around 3.5k from 1/17-1/20.

Nice work!!!
Marty