Sponsored
OP
OP
TroutHunter

TroutHunter

Badlands
Well-Known Member
Joined
Jan 26, 2021
Threads
12
Messages
195
Reaction score
564
Location
Michigan
Vehicle(s)
BMW 550
Your Bronco Model
Badlands
Clubs
 
After looking at the stats here, I really wonder if Ford even listened to their marketing research on colors. Or, they polled the wrong group. Take the Iconic Silver - I have to believe that some form of forest/deep/camo green (besides CG) would have been so much better received. Or, a better orange (less like a school bus), lighter blue than the AMB (but not to VB range), or (insert example from current color palate here). Area 51 is a cool color, but the only one of the group that is "different." Hence, the large skew of the data towards that color. So, after the release, it won't even be "different" any longer. Don't even get me started on the interiors....
Sponsored

 

SpaceHorse

Base
Well-Known Member
First Name
Eugene
Joined
Jan 25, 2021
Threads
0
Messages
50
Reaction score
42
Location
Az
Vehicle(s)
Explorer
Your Bronco Model
Base
* Updated 1/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 RegionRegion with highest percentage of given color across regions
ColorHighest %age
AMBNortheast
Area 51Mid-Atlantic
Cactus GrayWest
Carbonized GraySouth Central
Cyber OrangeNorthwest
Iconic SilverGreat Plains
Lightning BlueNorthwest
Oxford WhiteMidwest
Race RedNortheast
Rapid RedSouth Central
Shadow BlackGreat Plains
Velocity BlueGreat Plains
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:
MichiganCountPercentage
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%​
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.
You have way to much time on your hands.
 

4xFord

Badlands
Well-Known Member
First Name
Chris
Joined
Feb 7, 2021
Threads
5
Messages
118
Reaction score
287
Location
Denver
Vehicle(s)
Badlands
Your Bronco Model
Badlands
Clubs
 
Thanks for sharing the native file, good stuff. Unrelated to color I notice there's a lot of Grangers in the dealership column. Any chance a cell was accidently copied down? It shows up in nearly every state and Ford's website only recognizes dealerships in Louisiana & Iowa? Apologies if this has already been addressed or I'm oblivious to the Granger empire
EDIT: Put me down for oblivious. I've learned more about their nationwide sales and probably ought to check them out.
 

Razorbak86

Badlands
Well-Known Member
Joined
Jul 19, 2020
Threads
41
Messages
3,201
Reaction score
12,118
Location
Northwest Arkansas
Vehicle(s)
Ford Bronco, BMW R1150 GS
Your Bronco Model
Badlands
Clubs
 
I notice there's a lot of Grangers in the dealership column. Any chance a cell was accidently copied down? It shows up in nearly every state and Ford's website only recognizes dealerships in Louisiana & Iowa? Apologies if this has already been addressed or I'm oblivious to the Granger empire

EDIT: Put me down for oblivious. I've learned more about their nationwide sales and probably ought to check them out.
Granger has over 1,200 reservations in total from buyers all across the country.
 

AmberC

Wildtrak
Well-Known Member
First Name
Amber
Joined
Feb 26, 2021
Threads
4
Messages
52
Reaction score
72
Location
Poplar Bluff, MO
Vehicle(s)
Yukon Denali
Your Bronco Model
Wildtrak
* Updated 1/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 RegionRegion with highest percentage of given color across regions
ColorHighest %age
AMBNortheast
Area 51Mid-Atlantic
Cactus GrayWest
Carbonized GraySouth Central
Cyber OrangeNorthwest
Iconic SilverGreat Plains
Lightning BlueNorthwest
Oxford WhiteMidwest
Race RedNortheast
Rapid RedSouth Central
Shadow BlackGreat Plains
Velocity BlueGreat Plains
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:
MichiganCountPercentage
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%​
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.
Omg this is awesome. Thank u!
 

Sponsored

BearWithMe

Base
Well-Known Member
Joined
Aug 5, 2020
Threads
7
Messages
194
Reaction score
234
Location
West Slope, Colorado
Vehicle(s)
2018 Tacoma 6MT
Your Bronco Model
Base
While removing region for a national sampling, It's interesting to see:

  • 2.3 is at about a 3:1 take rate compared to 2.7. I would have expected that to be closer to 4:1 considering Americans like to America.
    • Edit: Technically at 26% it's darn close to 4:1 as anticipated, and as seen with Jeep. However, i'm no quitter. 26% is rounded up to 33% for purposes of not having to correct the original post.
    • 1614101144837.png
  • If we break it down by door/engine you see that 2-door folks are drastically more likely to choose the 2.3 and suddenly the Velocity Blue folks can be found as the majority and only time Area 51 isn't the highest take-rate color.
    • 4-door folks, predictably, overwhelmingly prefer the 2.7 and brushing their teeth while driving.

    • 1614101297691.png
And finally, you see that Iconic Silver totally sucks and nobody wants it. Meaning it will be the #1 or #2 color by sales within 3 years when dealerships take over the ordering from us heathens.
I completely agree with your analysis of the Iconic Silver situation once dealers start ordering for inventory...but I wish you were wrong!

I really like Iconic Silver on the 2-door -- it hits the perfect 1980s vibe for me and it will be a rare color combo for a few years.
 
OP
OP
TroutHunter

TroutHunter

Badlands
Well-Known Member
Joined
Jan 26, 2021
Threads
12
Messages
195
Reaction score
564
Location
Michigan
Vehicle(s)
BMW 550
Your Bronco Model
Badlands
Clubs
 
Updated main/initial posting with new spreadsheet showing comparisons from 2.22 to 3.8 order details. Color-coded percentage changes in regional colors on new tab to see trends between ordering periods.
 

MacDonald_Photo

Badlands
Well-Known Member
First Name
Jamie
Joined
Jul 17, 2020
Threads
67
Messages
772
Reaction score
2,977
Location
Eaton Rapids, Michigan
Vehicle(s)
2021 Badlands
Your Bronco Model
Badlands
Clubs
 
That ONE Carbonized Grey in Michigan is me! Who knew grey would stand out so much!? 😂😅😂
 

Coloradonatives

Badlands
Well-Known Member
First Name
Don
Joined
Mar 8, 2021
Threads
5
Messages
413
Reaction score
696
Location
Fort Collins, Colorado
Vehicle(s)
'69 Chevelle 2020 Chevy Traverse 2009 9-7x Aero
Your Bronco Model
Badlands
Clubs
 
Yes - the conclusions we can draw from this are clear. The northern states choose darker colors to match their darker psychological outlook because they are "blue" states with oppressive, corrupt and dictatorial democrat leaders. The southern states, on the other hand, have a lighter psychological outlook because ... well, they're just better. On behalf of Texas, please stop moving into our state. (just kidding around people - don't get mad) :)
The Great Plains?! Who the hell calls Colorado the Great Plains 😂 I’ve lived here 35 years, never seen or heard anyone call it that.
Maybe you did not go to school here? It has been a Great Plains state my entire life. And the highest state...!
 

BearWithMe

Base
Well-Known Member
Joined
Aug 5, 2020
Threads
7
Messages
194
Reaction score
234
Location
West Slope, Colorado
Vehicle(s)
2018 Tacoma 6MT
Your Bronco Model
Base
The Great Plains?! Who the hell calls Colorado the Great Plains 😂 I’ve lived here 35 years, never seen or heard anyone call it that.
Must be a Front Range thing. I just sort of pretend the eastern half of the state doesn't exist, and that keeps me happy in the mountains.
Sponsored

 
 


Top