1/23/2011

01-23-11 - Cars.com extraction

I wrote a little program to extract records from Cars.com and make charts. For example :

Subaru WRX'es :


2002 : median=  9394.00 mean=  9462.42 sdev=  1932.74
2003 : median=  9995.00 mean= 10287.76 sdev=  1667.03
2004 : median= 11495.00 mean= 11295.16 sdev=  2122.11
2005 : median= 13995.00 mean= 13306.94 sdev=  1892.77
2006 : median= 15995.00 mean= 15854.00 sdev=  2065.38
2007 : median= 17990.00 mean= 17455.84 sdev=  2029.77
2008 : median= 20500.00 mean= 20591.19 sdev=  1935.96
2009 : median= 23595.00 mean= 23540.47 sdev=  1523.07
2010 : median= 25900.00 mean= 25750.80 sdev=  3505.73
2011 : median= 25989.00 mean= 24726.00 sdev=  1786.15

The WRX results are roughly what our intuition expects. There is a small step down associated with model year, but the steady price decrease for increasing mileage is much stronger. This is however somewhat surprising because there was a major model change in 2008, and the 2008 cars are known to be much worse than the 2009's.

Porsche 911 3.8 S Manual Coupes :


2006 : median= 56900.00 mean= 55829.26 sdev= 4804.42
2007 : median= 61991.00 mean= 61161.85 sdev= 5069.27
2008 : median= 67981.00 mean= 68558.00 sdev= 4532.27
2009 : median= 79880.00 mean= 79492.58 sdev= 6171.92

The Porsche is the exact opposite of the WRX. I'm surprised at how stable prices are vs mileage, but there is a very steady step down with model year. This is also strange since the 2006-2008 cars are identical.

Honda Civics , Manual , excluding the new 2.0 I4 :


2000 : median=  6990.00 mean=  6978.33 sdev=   977.55
2001 : median=  7999.00 mean=  7999.00 sdev=     0.00
2002 : median=  7995.00 mean=  7472.50 sdev=   738.93
2003 : median=  6995.00 mean=  6852.88 sdev=  1109.37
2004 : median=  8995.00 mean=  8615.50 sdev=  1186.42
2005 : median=  8657.00 mean=  8710.30 sdev=  1412.42
2006 : median= 12495.00 mean= 12604.31 sdev=  2074.50
2007 : median= 12990.00 mean= 13538.41 sdev=  2174.33
2008 : median= 14694.00 mean= 14918.31 sdev=  2282.32
2009 : median= 17975.00 mean= 17244.96 sdev=  2532.70

Hondas behave strangely on the market. There is very little depreciation with mileage for a given model year. There is a big price step at 2006 when the new model came out - people seem to like the new one much better - but other than that there is very little depreciation with age either.

No comments:

old rants