I thought there was a lot of good information in the TSX Owner Sign-In thread so I compiled it into a database to make it easier for members to find pricing in their area.

Soopa is going to work on getting it online but in the meantime I thought I'd share some highlights of the collected data:

Most popular color combo: Carbon Grey Pearl / Ebony (23%)

Most popular transmission choice: AT (60%)

There are exactly the same number of people that have navi as those that don't (93 members each)

Average Pricing
2004 MY
Navi: $27,350.45
Non-Navi: $25,483.91

2005 MY
Navi: $28,085.47
Non-Navi: $26,118.74


So stay tuned for the database....

Edit: Removed cars with dealer-installed options from the averages.

 

Good stuff

 

Those Navi numbers may be scewed because of We should be able to pull the country info out right?

And another victory for the AT army

 

I separated out the Canadian prices so they don't affect the pricing. There really weren't many participants in the thread from Canada but I can still post statistics if we want.

 

Less people driving 6MT, is a MT victory. It increases our uniqueness.

 

Good info!

 

Most popular colour combo: Premium White Pearl / Ebony (35%) no surprises here...

Most popular transmission choice: AT (57%)

There are no members with Navi in Canada.

Average Pricing
2004 MY
Non-Navi: $33,612.00

2005 MY
Navi: No data
Non-Navi: $35,400.00

Edit: I put the 'U' back in colour where it belongs for us Canucks

 

Good stuff Dan,

Funny, I just thinking we should be doing something similar to this yesterday, as I was browsing that thread.

Beat me to it!

 

It was a bitch to do it but I thought it would be interesting. Nearly 4 hours of copying and pasting.

 

Damn, Dan, 4 hours? You must not have much to do after you get home from work...

 

@ after work

 

^^

 

Your boss must love the amount of dedication you put into here...

 

 

Well, you did put the "u" in the word colour, but you mis-spelled your own kind in the title ----> Candian.

:troutslap

 

Dan, did you find a way to deal with dealer installed options?

 

The database lists the installed options beside the price but there's really no way of me breaking them out separately. The best I can do is list all vehicles per state and let the members determine what's the best deal.

In a sense, those averages at the top will be inflated or deflated depending on options chosen. Perhaps I should do a separate average of cars without options...

 

See what the boss thinks, I'm sure he'll have some input.

 

Ok, I updated the first post to only include cars that have no options in the average. Then I thought of one other interesting stat: the average amount spent on dealer installed options

Average spent on dealer installed options:
2004
Navi: $956.27
Non-Navi: $159.84

2005
Navi: $575.43
Non-Navi: $341.26



So what does this mean?

It would appear that people who splurged on Navi also bought more options.

 

Out of respect for my workplace, I'm not going to analyze the Canadian data until I get home.

 

Very nice job! Thanks for taking the time to do it.

 

Bwahahaha.

 

this is what you TSX mods do

 

hmmm, maybe the navi owners are suckers for getting options installed at the dealership and non-navi owners do them for cheaper elsewhere.

but seriously, i wonder if we should've added our oem options and how much we paid for them and how much install cost. that would really help prospective buyers.

 

Good info Dan. Thanks for putting the time in.

+ 1

I do 95% of my posting from work. If I'm gonna get into trouble with the boss I guess we know which boss I fear more.

 

Glad you've got your priorities straight.

 

Okie...

The database is up and I put this rough interface on it

I'll expand upon this later, allowing you to add/update... and "slickifying" it a good bit.

I've semi-integrated this with the vbb database so I could in theory have this info flush out in your forum profile...

Anyway, it's a beginning. Good work putting all the shit together Dan

 

list is ordered by purchase date BTW. most recent purchase first

 

Wow, Feb. 23rd must have been a record sales day for Acura

Take a look at the link soop...

Edit: Woah, just saw that was 2005, today

 

doh nice catch

 

Nice work

 

fix0red kinda

 

Looking good,

 

So in what format was this exported out of ebullettin in?

 

Nice work

Edit: noticed answer in post above.

 

exported in Dan Martin hard-labor file format.

then I just cleaned up his CSV, created a database, and imported his data.

now it is stored in MySQL and full of wonderful whizzy querying potential.

 

Geez, nice work Dan.

 

Thanks!

 

Wow, actual useful stuff here...

 

Who would have thought...