TSX Owner Sign-In Database
02-22-2005, 11:53 AM
#1
Photography Nerd
Thread Starter
TSX Owner Sign-In Database
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.
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.
02-22-2005, 11:59 AM
#4
Photography Nerd
Thread Starter
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.
02-22-2005, 12:02 PM
#5
My Garage
Originally Posted by domn
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
We should be able to pull the country info out right?And another victory for the AT army
02-22-2005, 12:06 PM
#7
Photography Nerd
Thread Starter
Canadian Owners Stats
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 
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
Trending Topics
02-22-2005, 12:36 PM
#9
Photography Nerd
Thread Starter
Originally Posted by sauceman
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!
Funny, I just thinking we should be doing something similar to this yesterday, as I was browsing that thread.
Beat me to it!
Damn, Dan, 4 hours? You must not have much to do after you get home from work...
02-22-2005, 03:33 PM
#15
Originally Posted by Dan Martin
Edit: I put the 'U' back in colour where it belongs for us Canucks
Well, you did put the "u" in the word colour, but you mis-spelled your own kind in the title ----> Candian. :troutslap
02-22-2005, 03:49 PM
#17
Photography Nerd
Thread Starter
Originally Posted by fdl
Dan, did you find a way to deal with dealer installed options?
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...
02-22-2005, 03:57 PM
#18
Senior Moderator
Originally Posted by Dan Martin
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...
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.
02-22-2005, 04:03 PM
#19
Photography Nerd
Thread Starter
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.
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.
02-22-2005, 04:04 PM
#20
Photography Nerd
Thread Starter
Originally Posted by domn
See what the boss thinks, I'm sure he'll have some input.
02-23-2005, 05:47 PM
#24
Drifting
Join Date: Mar 2004
Location: nerdlingerton
Age: 44
Posts: 2,242
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Dan Martin
It would appear that people who splurged on Navi also bought more options.
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.
02-23-2005, 06:08 PM
#25
Team Owner
Good info Dan. Thanks for putting the time in.
@ after work
+ 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.
Originally Posted by Dan Martin
@ after work + 1I 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.
02-23-2005, 07:38 PM
#27
The Creator
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
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
02-23-2005, 07:55 PM
#29
Just dial 1911
Join Date: May 2004
Location: San Diego, CA
Age: 49
Posts: 12,144
Likes: 0
Received 1 Like
on
1 Post
Originally Posted by soopa
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
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
Take a look at the link soop...
Edit: Woah, just saw that was 2005, today
02-24-2005, 10:56 AM
#36
The Creator
Originally Posted by domn
So in what format was this exported out of ebullettin in?
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.
02-24-2005, 11:28 AM
#37
Senior Moderator
Originally Posted by soopa
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.
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.
02-24-2005, 11:39 AM
#39
Go Giants
Wow, actual useful stuff here...