Summer Olympic Games Paris 2024 Medal Count

[tirtha22 238]

Rowers from Ireland Philip Doyle and Daire Lynch had their bronze medals taken back by authorities to research on "chronic issue" of the medals. They have been replaced with new medals

[Monzanator 4,888]

Looks like had their big welcome party yesterday

 

 

 

[Siddhartha Talukdar 249]

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

Edited August 29, 2024 by Siddhartha Talukdar

[Grassmarket 4,166]

1 hour ago, Siddhartha Talukdar said:

Hi @Gianlu33, @Griff88, @JoshMartini007, @mpjmcevoy, @vinipereira, @Vic Liu, @Cinnamon Bun, @hckošice, @rybak, @Josh, @avlar, @heywoodu, @Epic Failure, @phelps, @ChandlerMne @Grassmarket, @De_Gambassi, @Olympian1010 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 482.48 kB · 15 downloads

Now, cross tab that with a population size table.......

[De_Gambassi 1,312]

2 hours ago, Siddhartha Talukdar said:

Hi @Gianlu33, @Griff88, @JoshMartini007, @mpjmcevoy, @vinipereira, @Vic Liu, @Cinnamon Bun, @hckošice, @rybak, @Josh, @avlar, @heywoodu, @Epic Failure, @phelps, @ChandlerMne @Grassmarket, @De_Gambassi, @Olympian1010 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 482.48 kB · 16 downloads

I'll take your points table over the medals table we have now everyday !

 

I think there is value in a 'normalized points' table that would weight each event slightly different. But in your case, that's might be a bit too much and it's killing it IMO. Probably, there is a mathematical formula that would work better 

[Siddhartha Talukdar 249]

22 minutes ago, De_Gambassi said:

I'll take your points table over the medals table we have now everyday !

 

I think there is value in a 'normalized points' table that would weight each event slightly different. But in your case, that's might be a bit too much and it's killing it IMO. Probably, there is a mathematical formula that would work better 

The intention of introducing the term to check which nations do well in multiple sports and not just in 1-2 sports. Or sometimes the medal table gets skewed if in a sport extra events are added/deleted or there restrictions in participation itself which may not favour the dominating country (Eg Participation in Weightlifting restricted to 3 in each gender).

So would like to know your ideas, how would you calculate 'Normalized Points'. How is winning 100m Freestyle different from winning Handball event

[Gianlu33 5,633]

Wrong theared.

Edited August 29, 2024 by Gianlu33

[OlympicIRL 6,218]

6 hours ago, Siddhartha Talukdar said:

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 482.48 kB · 32 downloads

I didn’t have time to review yet but Ireland had way more than 88 quotas if I am assuming you mean quotas = athletes?

[Siddhartha Talukdar 249]

33 minutes ago, OlympicIRL said:

I didn’t have time to review yet but Ireland had way more than 88 quotas if I am assuming you mean quotas = athletes?

No quotas basically means maximum number of placings possible in an event. So for example, Ireland participated in Men's Hockey there were 16 athletes but just 1 quota as the team can have just 1 placing

Edited August 29, 2024 by Siddhartha Talukdar

[OlympicIRL 6,218]

56 minutes ago, Siddhartha Talukdar said:

No quotas basically means maximum number of placings possible in an event. So for example, Ireland participated in Men's Hockey there were 16 athletes but just 1 quota as the team can have just 1 placing

Got you, that makes sense