GREAT post RacerXwing, I hope that we can add you to the group of MI NSX owners fairly soon!
This is good info, thanks for posting it.
Great post! I did a similar thing when I was shopping, but in much less detail and focus.
Wow, this is truly impressive! I'd hate to think how long this took to compile. Thanks for taking the time!
Thanks a lot everyone! I hope to join the family of NSX owners soon.
I have to agree - what a great job making the data visual and easy to understand. I've been looking for an NSX for over a year and your conclusions mirror what I've been seeing as well. There are lots of variables (time of the year, location in the US, condition of the car) which are sometimes hard to capture but as a rule of thumb I'd say you nailed it. Would be interesting to see if the sale numbers (by color say) match the percentage of the production numbers. Folks should remember that the listing price is not often the sales price, but gives the same trends and relative data. Glad you've been lurking!
Thanks for your good comments. Ask and you shall receive...
I've compared my dataset to the full US production numbers data on Prime. In general, there is a good agreement. Some notable conclusions:
- Formula Red and Berlina Black are even more dominant in the full production population.
- Rio Yellow, Midnight, Monte Carlo Blue, Imola Orange, and Monaco Blue share similarly sized small slices at the bottom, but are in a different order.
thanks for crunching the numbers....would be interesting to break down stats further into exterior/interior color combos...
Luckily, I already have this handy! I chose not to include it in the main post because I felt it would have bogged it down too much, but I'm happy to share it. Note that I don't differentiate between Tan and Camel or Onyx and Black.
<style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>[TABLE="class: outer_border, width: 900"]
<tbody>[TR]
[TD]
Exterior Color[/TD]
[TD]
Interior Color[/TD]
[TD]
COUNT[/TD]
[TD]
Most Recent Listing Date[/TD]
[TD]
MIN of Miles[/TD]
[TD]
AVERAGE of Miles[/TD]
[TD]
MAX of Miles[/TD]
[/TR]
[TR]
[TD]Berlina Black[/TD]
[TD]Black[/TD]
[TD="align: right"]170[/TD]
[TD="align: right"]1/27/2017[/TD]
[TD="align: right"]1,393[/TD]
[TD="align: right"]75,873[/TD]
[TD="align: right"]222,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Custom[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]48,800[/TD]
[TD="align: right"]120,570[/TD]
[TD="align: right"]209,052[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ivory[/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]23,374[/TD]
[TD="align: right"]89,540[/TD]
[TD="align: right"]205,510[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Red[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]7/20/2015[/TD]
[TD="align: right"]90,350[/TD]
[TD="align: right"]90,350[/TD]
[TD="align: right"]90,350[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]38[/TD]
[TD="align: right"]1/4/2017[/TD]
[TD="align: right"]6,800[/TD]
[TD="align: right"]73,203[/TD]
[TD="align: right"]172,000[/TD]
[/TR]
[TR]
[TD]
Berlina Black Total[/TD]
[TD][/TD]
[TD="align: right"]261[/TD]
[TD="align: right"]1/27/2017[/TD]
[TD="align: right"]1,393[/TD]
[TD="align: right"]79,452[/TD]
[TD="align: right"]222,000[/TD]
[/TR]
[TR]
[TD]Brooklands Green[/TD]
[TD]Tan[/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]1/22/2017[/TD]
[TD="align: right"]24,385[/TD]
[TD="align: right"]81,328[/TD]
[TD="align: right"]161,000[/TD]
[/TR]
[TR]
[TD]
Brooklands Green Total[/TD]
[TD][/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]1/22/2017[/TD]
[TD="align: right"]24,385[/TD]
[TD="align: right"]81,328[/TD]
[TD="align: right"]161,000[/TD]
[/TR]
[TR]
[TD]Custom[/TD]
[TD] Type R[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5/13/2016[/TD]
[TD="align: right"]53,000[/TD]
[TD="align: right"]66,000[/TD]
[TD="align: right"]79,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Black[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1/12/2017[/TD]
[TD="align: right"]26,476[/TD]
[TD="align: right"]99,425[/TD]
[TD="align: right"]256,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Custom[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]54,951[/TD]
[TD="align: right"]88,795[/TD]
[TD="align: right"]104,121[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ivory[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]7/25/2016[/TD]
[TD="align: right"]79,000[/TD]
[TD="align: right"]79,300[/TD]
[TD="align: right"]79,900[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]1/17/2017[/TD]
[TD="align: right"]27,647[/TD]
[TD="align: right"]80,774[/TD]
[TD="align: right"]100,695[/TD]
[/TR]
[TR]
[TD]
Custom Total[/TD]
[TD][/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]26,476[/TD]
[TD="align: right"]91,789[/TD]
[TD="align: right"]256,000[/TD]
[/TR]
[TR]
[TD]Formula Red[/TD]
[TD]Black[/TD]
[TD="align: right"]234[/TD]
[TD="align: right"]1/26/2017[/TD]
[TD="align: right"]5,433[/TD]
[TD="align: right"]66,732[/TD]
[TD="align: right"]285,790[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Custom[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1/24/2017[/TD]
[TD="align: right"]81,000[/TD]
[TD="align: right"]113,390[/TD]
[TD="align: right"]176,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Ivory[/TD]
[TD="align: right"]21[/TD]
[TD="align: right"]1/29/2017[/TD]
[TD="align: right"]11,814[/TD]
[TD="align: right"]71,964[/TD]
[TD="align: right"]166,700[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]27[/TD]
[TD="align: right"]1/25/2017[/TD]
[TD="align: right"]9,625[/TD]
[TD="align: right"]60,448[/TD]
[TD="align: right"]137,800[/TD]
[/TR]
[TR]
[TD]
Formula Red Total[/TD]
[TD][/TD]
[TD="align: right"]292[/TD]
[TD="align: right"]1/29/2017[/TD]
[TD="align: right"]5,433[/TD]
[TD="align: right"]68,125[/TD]
[TD="align: right"]285,790[/TD]
[/TR]
[TR]
[TD]Grand Prix White[/TD]
[TD] Type R[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]1/9/2016[/TD]
[TD="align: right"]59,624[/TD]
[TD="align: right"]88,812[/TD]
[TD="align: right"]118,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Black[/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]3,007[/TD]
[TD="align: right"]68,140[/TD]
[TD="align: right"]131,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Custom[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]2/2/2015[/TD]
[TD="align: right"]105,800[/TD]
[TD="align: right"]105,800[/TD]
[TD="align: right"]105,800[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12/30/2016[/TD]
[TD="align: right"]12,546[/TD]
[TD="align: right"]69,809[/TD]
[TD="align: right"]138,049[/TD]
[/TR]
[TR]
[TD]
Grand Prix White Total[/TD]
[TD][/TD]
[TD="align: right"]44[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]3,007[/TD]
[TD="align: right"]70,201[/TD]
[TD="align: right"]138,049[/TD]
[/TR]
[TR]
[TD]Imola Orange[/TD]
[TD]Black[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]11/21/2016[/TD]
[TD="align: right"]38,448[/TD]
[TD="align: right"]38,448[/TD]
[TD="align: right"]38,448[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Orange[/TD]
[TD="align: right"]8[/TD]
[TD="align: right"]1/11/2017[/TD]
[TD="align: right"]15,500[/TD]
[TD="align: right"]31,313[/TD]
[TD="align: right"]59,000[/TD]
[/TR]
[TR]
[TD]
Imola Orange Total[/TD]
[TD][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"]1/11/2017[/TD]
[TD="align: right"]15,500[/TD]
[TD="align: right"]32,105[/TD]
[TD="align: right"]59,000[/TD]
[/TR]
[TR]
[TD]Kaiser Silver[/TD]
[TD]Black[/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]1/27/2017[/TD]
[TD="align: right"]23,610[/TD]
[TD="align: right"]70,221[/TD]
[TD="align: right"]182,486[/TD]
[/TR]
[TR]
[TD]
Kaiser Silver Total[/TD]
[TD][/TD]
[TD="align: right"]16[/TD]
[TD="align: right"]1/27/2017[/TD]
[TD="align: right"]23,610[/TD]
[TD="align: right"]70,221[/TD]
[TD="align: right"]182,486[/TD]
[/TR]
[TR]
[TD]Long Beach Blue[/TD]
[TD] Type R[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6/23/2016[/TD]
[TD="align: right"]44,495[/TD]
[TD="align: right"]44,495[/TD]
[TD="align: right"]44,495[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Black[/TD]
[TD="align: right"]7[/TD]
[TD="align: right"]12/23/2016[/TD]
[TD="align: right"]31,000[/TD]
[TD="align: right"]37,166[/TD]
[TD="align: right"]52,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Blue[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1/9/2017[/TD]
[TD="align: right"]7,949[/TD]
[TD="align: right"]31,410[/TD]
[TD="align: right"]45,150[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1/12/2017[/TD]
[TD="align: right"]22,000[/TD]
[TD="align: right"]35,721[/TD]
[TD="align: right"]59,700[/TD]
[/TR]
[TR]
[TD]
Long Beach Blue Total[/TD]
[TD][/TD]
[TD="align: right"]18[/TD]
[TD="align: right"]1/12/2017[/TD]
[TD="align: right"]7,949[/TD]
[TD="align: right"]35,573[/TD]
[TD="align: right"]59,700[/TD]
[/TR]
[TR]
[TD]Midnight[/TD]
[TD]Tan[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]12/15/2016[/TD]
[TD="align: right"]41,000[/TD]
[TD="align: right"]90,623[/TD]
[TD="align: right"]115,869[/TD]
[/TR]
[TR]
[TD]
Midnight Total[/TD]
[TD][/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]12/15/2016[/TD]
[TD="align: right"]41,000[/TD]
[TD="align: right"]90,623[/TD]
[TD="align: right"]115,869[/TD]
[/TR]
[TR]
[TD]Monaco Blue[/TD]
[TD]Black[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]5/7/2016[/TD]
[TD="align: right"]49,000[/TD]
[TD="align: right"]49,000[/TD]
[TD="align: right"]49,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]6/26/2015[/TD]
[TD="align: right"]32,200[/TD]
[TD="align: right"]32,200[/TD]
[TD="align: right"]32,200[/TD]
[/TR]
[TR]
[TD]
Monaco Blue Total[/TD]
[TD][/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]5/7/2016[/TD]
[TD="align: right"]32,200[/TD]
[TD="align: right"]40,600[/TD]
[TD="align: right"]49,000[/TD]
[/TR]
[TR]
[TD]Monte Carlo Blue[/TD]
[TD]Black[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]11/26/2014[/TD]
[TD="align: right"]85,557[/TD]
[TD="align: right"]85,557[/TD]
[TD="align: right"]85,557[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]4[/TD]
[TD="align: right"]12/8/2016[/TD]
[TD="align: right"]27,300[/TD]
[TD="align: right"]67,378[/TD]
[TD="align: right"]147,000[/TD]
[/TR]
[TR]
[TD]
Monte Carlo Blue Total[/TD]
[TD][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]12/8/2016[/TD]
[TD="align: right"]27,300[/TD]
[TD="align: right"]71,014[/TD]
[TD="align: right"]147,000[/TD]
[/TR]
[TR]
[TD]New Formula Red[/TD]
[TD]Black[/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]7,972[/TD]
[TD="align: right"]39,343[/TD]
[TD="align: right"]103,300[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tan[/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]11/25/2016[/TD]
[TD="align: right"]17,078[/TD]
[TD="align: right"]33,810[/TD]
[TD="align: right"]113,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Zanardi Black[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]4/4/2016[/TD]
[TD="align: right"]33,848[/TD]
[TD="align: right"]55,424[/TD]
[TD="align: right"]77,000[/TD]
[/TR]
[TR]
[TD]
New Formula Red Total[/TD]
[TD][/TD]
[TD="align: right"]28[/TD]
[TD="align: right"]1/23/2017[/TD]
[TD="align: right"]7,972[/TD]
[TD="align: right"]38,120[/TD]
[TD="align: right"]113,000[/TD]
[/TR]
[TR]
[TD]Rio Yellow[/TD]
[TD]Black[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]1/24/2017[/TD]
[TD="align: right"]3,524[/TD]
[TD="align: right"]28,507[/TD]
[TD="align: right"]83,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Yellow[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]8/24/2016[/TD]
[TD="align: right"]11,002[/TD]
[TD="align: right"]32,662[/TD]
[TD="align: right"]43,568[/TD]
[/TR]
[TR]
[TD]
Rio Yellow Total[/TD]
[TD][/TD]
[TD="align: right"]14[/TD]
[TD="align: right"]1/24/2017[/TD]
[TD="align: right"]3,524[/TD]
[TD="align: right"]29,397[/TD]
[TD="align: right"]83,000[/TD]
[/TR]
[TR]
[TD]Sebring Silver[/TD]
[TD]Black[/TD]
[TD="align: right"]39[/TD]
[TD="align: right"]1/17/2017[/TD]
[TD="align: right"]6,500[/TD]
[TD="align: right"]76,031[/TD]
[TD="align: right"]340,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Custom[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1/1/2017[/TD]
[TD="align: right"]70,000[/TD]
[TD="align: right"]82,370[/TD]
[TD="align: right"]90,610[/TD]
[/TR]
[TR]
[TD]
Sebring Silver Total[/TD]
[TD][/TD]
[TD="align: right"]42[/TD]
[TD="align: right"]1/17/2017[/TD]
[TD="align: right"]6,500[/TD]
[TD="align: right"]76,484[/TD]
[TD="align: right"]340,000[/TD]
[/TR]
[TR]
[TD]Silverstone[/TD]
[TD]Black[/TD]
[TD="align: right"]49[/TD]
[TD="align: right"]1/27/2017[/TD]
[TD="align: right"]7,498[/TD]
[TD="align: right"]45,011[/TD]
[TD="align: right"]137,000[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Silver[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]3/7/2016[/TD]
[TD="align: right"]12,300[/TD]
[TD="align: right"]38,910[/TD]
[TD="align: right"]66,000[/TD]
[/TR]
[TR]
[TD]
Silverstone Total[/TD]
[TD][/TD]
[TD="align: right"]54[/TD]
[TD="align: right"]1/27/2017[/TD]
[TD="align: right"]7,498[/TD]
[TD="align: right"]44,446[/TD]
[TD="align: right"]137,000[/TD]
[/TR]
[TR]
[TD]Spa Yellow[/TD]
[TD]Black[/TD]
[TD="align: right"]32[/TD]
[TD="align: right"]1/14/2017[/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]41,688[/TD]
[TD="align: right"]95,327[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Custom[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]1/14/2014[/TD]
[TD="align: right"]20,298[/TD]
[TD="align: right"]20,298[/TD]
[TD="align: right"]20,298[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Yellow[/TD]
[TD="align: right"]1[/TD]
[TD="align: right"]3/18/2015[/TD]
[TD="align: right"]57,320[/TD]
[TD="align: right"]57,320[/TD]
[TD="align: right"]57,320[/TD]
[/TR]
[TR]
[TD]
Spa Yellow Total[/TD]
[TD][/TD]
[TD="align: right"]34[/TD]
[TD="align: right"]1/14/2017[/TD]
[TD="align: right"]10,000[/TD]
[TD="align: right"]41,518[/TD]
[TD="align: right"]95,327[/TD]
[/TR]
</tbody>[/TABLE]
Mmmmm data candy! Your not some derivatives analyst for some investment bank on the side are you?
You sales data confirmed what I suspected, that my Monaco Blue Pearl is the rarest of the rare (or the most unloved). The only caution, which you have noted, is that the prices are asks. The asks for the 'modified' category may reflect seller bias rather than clearing price. Unfortunately, without clearing prices, my speculation is impossible to confirm.
Nice work.
An interesting note is that Monaco Blue is the one color in my dataset where an automatic transmission has yet to surface. I'd love to see more sales of Monaco and Monte Carlo Blue. They are criminally underrepresented at the moment. An excellent point about the modified prices; maybe someday I'll have enough auction / clearing price data to build a separate model...