Challenge #277: 2016 Summer Olympics

A solution to last week’s challenge can be found here.https://commons.wikimedia.org/wiki/File:Olympic_rings_without_rims.svg

As we gear up for the 2021 Summer Olympics, let's take a look back at the countries and athletes that participated in the last Summer Olympics.

- The "athletes" dataset contains data about the athletes who competed in the 2016 Summer Olympics in Rio de Janeiro.
- The "countries" dataset contains the International Olympic Committee country code.

Find the following for each country:
- The sport with the most athletes
- The total number of athletes
- The total number of female athletes
- The total number of male athletes, and
- The average age of all athletes for each country

Hint for the 2016 Summer Olympics

Opening Date: August 5^th, 2016

Closing Date: August 21^st, 2016

challenge_277_start_file.yxzp

challenge_277_solution.yxzp

Parse

Join

Preparation

Data Analysis

Intermediate

Core

Transform

Accepted answers

All comments

snbandi

There are 6 records with DOB with 1950s that Date parse is going to throw up with negative age differences. Had to some crazy formulae to subtract 100 years from those dates.

challenge_277_SB.yxmd

danbostrom

challenge_277_solution.yxmd

houghton17

Solved, good challenge!

asultanov

Spoiler

challenge_277_complete.yxmd

Dibas98

Solution

challenge_277_start_file.yxmd

YadTheTabLad

challenge_277_start_file.yxzp

Mikeimbi

Challenge 277

challenge_277_solution_file.yxmd

Shaktikdhar

My Solution

Spoiler

challenge_277_solution_file.yxmd

Shahbaz_analyst

Spoiler

challenge_277_start_file.yxmd

Bobbyt23

Good challenge. Based my age on today's date so slightly different to the final solution, but everything else matched.

Weekly Challenge 277 20-05-24.yxzp

Axelar

#Solution

challenge_277_start_file.yxmd

Supriya2203

My solution

challenge_277 solution.yxmd

ChrisMelck

Citius-Altius-Fortius

challenge_277_solution.yxmd

lwolfie

Another Olympics one done!

challenge_277_solution_LW.yxmd

SammiJohnson

My solution 🙂

SJ Challenge 277 Solution.yxmd

JoePC

Solution Attached

277.yxmd

martinson

Attempt 1

challenge_277_start_file.yxmd

cmoussa

challenge_277 CTM.yxmd

rob_wand204

Weekly_Challenge_277.yxmd

JBevan89

My Solution attached.

The Output results is clearly incorrect in places because of Null values not being able to be added to make total athletes

challenge_277_JB.yxmd

mwong

My solution

challenge_277.yxmd

leipann

#277

challenge_277_start_file.yxmd

RebekaMazuchova

challenge_277_RM.yxmd

BS_THE_ANALYST

Answer created their total column via a formula (I guess) as if a null was present, this forces the total to be null (formula tool behaviour unlike crosstab/summarise). A tad annoying! The Age calculation was also interesting to figure out, I assumed the date to be the start of the event.

Not an Olympic challenge completion time for me!

Spoiler

Time taken: 14:44
Screenshot 2025-05-26 191510.png

challenge_277_start_file.yxmd

jwbtx20

Fun & quick challenge! I was able to avoid the "null" issues using the summarize tool & counts (did a formula to create "tag" columns for female vs. male athletes).

challenge_277_start_file.yxmd

Pilsner

My solution:

Spoiler

Not sure of the exact date used to calculate the athletes age but I got everything else to match.

277 (2016 Summer Olympics).yxzp

aiahwieder

A classic case where SORTING matters when RANKING.

Challenge 277_solution.yxzp

JessicaEP

Completed! Then I had a thought: The smallest teams were countries that only sent two athletes- what's the smallest team that actually brought home a medal? So to satisfy my own curiosity I did a little bonus analysis and found the answer:

Spoiler

Niger, with a team of only 6, brought home one silver medal.

challenge_277_JEP Complete.yxmd

estherb47

Spoiler

challenge_277_EHB_completed.yxzp

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

JeffF 335