Analysing which colour contributes to the greatest price premium

[Jacob Daniel]

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.

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.

[Jacob Daniel]

Bump

[Chen Samulsion]

bysort Colour: egen total_PricePrem=total(PricePrem)
bysort Colour: egen mean_PricePrem=mean(PricePrem)
label var total_PricePrem "sum of Price Premium by Colour"
label var mean_PricePrem "mean of Price Premium by Colour"
tabstat total_PricePrem mean_PricePrem, by(Colour)