Hi Everyone,

I hope you're well!

I am trying to observe what colours have the greatest price premium.
Here is a sample of my data.

Code:
input str39 Name str10 Colour double PricePrem
"Nike Jordan 5 Anthracite "               "Black"       .42420856610800745
"Nike Jordan 5 Bluebird "                 "Blue"       .030324074074074128
"Nike Jordan 5 Stealth "                  "White"       .09473514211886298
"Nike Jordan 5 Raging Red"                "Red"         .09351276742581088
"Nike Jordan 5 Jade Horizon"              "Green"      -.16124885215794302
"Nike Jordan 5 Regal Pink"                "Pink"       -.07519561815336462
"Nike Jordan 5 Racer Blue GS"             "Black"        .4017045454545455
"Nike Jordan 5 Racer Blue"                "Black"       .10600978336827388
"Nike Jordan 5 White Laser Crimson GS"    "Pink"        -.2026679221594476
"Nike Jordan 5 Island Green "             "Green"        .2978535353535354
How can I analyse which colour (black,red or whatever colour) has the greatest price price premium?

e.g the Colour black typically correlates to a high price premium percentage. What sort of analysis am I looking for here?

Thanks in advance for your help. Take care.