Hi @Gianlu33, @Griff88, @JoshMartini007, @mpjmcevoy, @vinipereira, @Vic Liu, @Cinnamon Bun, @hckošice, @rybak, @Josh, @avlar, @heywoodu, @Epic Failure, @phelps, @ChandlerMne @Grassmarket, @De_Gambassi, @Olympian1010, @konig, @Monzanator , @dodge, @PHI2019, @Fer GUA Attached is points table based on Top 8 performance in each event where 1st place gets 10 points, 2nd gets 7 pts, 3rd gets 5, 4th gets 2.5, 5th gets 2,6th gets 1.5, 7th gets 1 and 8th gets 0.5 pts. To measure nations' performance few terms have been introduced
'Quota' is number of participants per country in each event. Qualified but non-participation is not included in Quota.
'Top 8' is the number of events a country finished in Top 8.
Conversion = Top 8 / Quota which implies Contingent quality.
'Normalized Points' = Points / (Number of events in that sport). For example, if a country wins just 1 Gold in Archery, they will get 10 points but 10 points/ 5 events = 2 Normalized Points. This metric will be high for countries who earn points in multiple sports.
Aquatics events has been divided into sports like 'Artistic Swimming', 'Swimming', 'Water Polo' and 'Diving' otherwise 'Sport' can be defined as set of events governed by same federation
Salient Observations
1) The nations' rank for points is closely related to rank of total medals won
2) is ahead of in points table by a fair distance but very close in Normalized Points as dominates multiple sports like Diving, Table Tennis, Badminton
3) Countries like , , , are ranked high in points table but low in Normalized Points as they won medals in very few sports
4) Despite winning no medals,countries like , , have earned decent points
Please put in your comments and feedback. There might be data errors due to primary data errors, misinterpretation, or less information on a sport
Olympics_2024.xlsx