- Thread starter
- #1
*Updated 3/8 - New spreadsheet uploaded with activity through March 8th. New tab outlining differences in color preferences between 2.22 orders and 3.8 orders. Color-coded difference column shows green for increases and red for decreases in percentage-takes of each color by region.
* Updated 2/23 - Colorado now in West region, Alabama in Southeast. Also, table had some incorrect percentage calculations, so those are updated. Lastly, Color category percentages now reflect percentage of overall orders. Charts below and attachment reflect latest version.
I was curious about how color choices might vary by region. So, I took the order data from the submitted orders list, classified each location by a general region, and ran a pivot table by region and then by color. (One could also run it by trim and by any of the other data in the order spreadsheet, but I focused on color here). I wanted to see what colors I will be seeing on the road more locally. I had suspected that certain colors would be more popular in certain areas. The "darks" seem to be more favored in the northern states. I did my best to incorporate data from our Canadian friends here as well and included them in the general classifications.
I have attached the Excel data and associated pivot table here for those who are familiar with how to use them. I made a new Region column to the data and also differentiated by Country if our Neighbors to the North would like to see their own results. You can filter/add your own state in there as well. Here is Michigan:
Michigan has a higher AMB percentage than the national average. While these might not be "statistically significant" sample sizes just yet when sliced this thinly, it is getting very close, if it isn't there already - we have a good sample size from all of this data. I haven't run a regression analysis or looked at variances, confidence intervals, etc. quite yet to test it all out, so take it for what it's worth.
Play with the attached file - it is fun to move the pivot table around to see all of the different "cuts" and "combos" to see how many Squatched 4-door AMB Badlands MIC 2.7s are going to be running around Michigan! Interesting tidbit - the only region that did not have Area 51 as the top color choice was the Great Plains with Cactus Gray. The second tab of the data is the Regional classification. I put the Canadian orders into the most appropriate Regional slot and did my best with the other assignments. Sorry if there are any incorrect alignments or oversights.
* Updated 2/23 - Colorado now in West region, Alabama in Southeast. Also, table had some incorrect percentage calculations, so those are updated. Lastly, Color category percentages now reflect percentage of overall orders. Charts below and attachment reflect latest version.
I was curious about how color choices might vary by region. So, I took the order data from the submitted orders list, classified each location by a general region, and ran a pivot table by region and then by color. (One could also run it by trim and by any of the other data in the order spreadsheet, but I focused on color here). I wanted to see what colors I will be seeing on the road more locally. I had suspected that certain colors would be more popular in certain areas. The "darks" seem to be more favored in the northern states. I did my best to incorporate data from our Canadian friends here as well and included them in the general classifications.
By Color, Then By Region | Region with highest percentage of given color across regions |
Color | Highest %age |
AMB | Northeast |
Area 51 | Mid-Atlantic |
Cactus Gray | West |
Carbonized Gray | South Central |
Cyber Orange | Northwest |
Iconic Silver | Great Plains |
Lightning Blue | Northwest |
Oxford White | Midwest |
Race Red | Northeast |
Rapid Red | South Central |
Shadow Black | Great Plains |
Velocity Blue | Great Plains |
Michigan | Count | Percentage |
Antimatter Blue | 11 | 12.09% |
Area 51 | 18 | 19.78% |
Cactus Gray | 17 | 18.68% |
Carbonized Gray | 1 | 1.10% |
Cyber Orange | 10 | 10.99% |
Iconic Silver | 4 | 4.40% |
Oxford White | 13 | 14.29% |
Race Red | 4 | 4.40% |
Rapid Red | 1 | 1.10% |
Shadow Black | 6 | 6.59% |
Velocity Blue | 6 | 6.59% |
Play with the attached file - it is fun to move the pivot table around to see all of the different "cuts" and "combos" to see how many Squatched 4-door AMB Badlands MIC 2.7s are going to be running around Michigan! Interesting tidbit - the only region that did not have Area 51 as the top color choice was the Great Plains with Cactus Gray. The second tab of the data is the Regional classification. I put the Canadian orders into the most appropriate Regional slot and did my best with the other assignments. Sorry if there are any incorrect alignments or oversights.
Sponsored
Attachments
-
548.7 KB Views: 534
Last edited: