Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #384: Uncover Tennis Stats Upsets!

AYXAcademy
Alteryx
Alteryx

 

A solution to last week’s challenge can be found here.

 

FAN-Q3_media-component_600x605.jpg

In this challenge, you have a dataset with statistics from men’s singles tennis tournaments around the world. Your task is to determine who won the final with the biggest average rank difference in a tournament that had at least 20 final rounds.

 

To find the answer, use the Match Data dataset to complete the following tasks:

 

  1. Find the average rank difference between the winner and loser in tournaments with data for 20 or more finals. Only consider tournaments where the Round value = The Final.
  2. Identify the tournament that most likely caused an upset. This will be the tournament with the highest average rank difference.
  3. Determine the name of the player who had the most wins in the tournament final identified in the prior task and how many times this player won this particular tournament.

 

Good luck!

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
ahsanaali
11 - Bolide

See solution attached.

Spoiler
 
Screenshot 2023-08-14 171035.png
Flo_P
8 - Asteroid
Spoiler
Fun one but not sure about the validity of this stat
image.png
mmontgomery
11 - Bolide

c384

Spoiler
Had the 'upset' ranking sorted incorrect for a while, that was the bug to fix
RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
384.png
ed_hayter
12 - Quasar
Spoiler
Tennis Time

Challenge 384 WF Image.png

Give us Table Tennis Next!
kmbassett01
8 - Asteroid

Happy Monday! Thanks for the fun challenge :)

nSpire
8 - Asteroid
Spoiler
384.png
nhardin
7 - Meteor
Spoiler
Solution for challenge # 384Solution for challenge # 384