cancel
Showing results for 
Search instead for 
Did you mean: 

Challenge #384: Uncover Tennis Stats Upsets!

AYXAcademy
Alteryx

Challenge #384: Uncover Tennis Stats Upsets!

 

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!

 

Attachment
Download this attachment
Attachment
Download this attachment
Attachment
Download this attachment
193 REPLIES 193
AYXAcademy
Alteryx

Challenge #384: Uncover Tennis Stats Upsets!

 

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!

 

Attachment
Download this attachment
Attachment
Download this attachment
Attachment
Download this attachment
Kenda
16 - Nebula

Re: Challenge #384: Uncover Tennis Stats Upsets!

Spoiler
image.png
Attachment
Download this attachment
ahsanaali
11 - Bolide

Re: Challenge #384: Uncover Tennis Stats Upsets!

See solution attached.

Spoiler
 
Screenshot 2023-08-14 171035.png
Attachment
Download this attachment
Flo_P
Comet

Re: Challenge #384: Uncover Tennis Stats Upsets!

Spoiler
Fun one but not sure about the validity of this stat
image.png
Attachment
Download this attachment
mmontgomery
11 - Bolide

Re: Challenge #384: Uncover Tennis Stats Upsets!

c384

Spoiler
Had the 'upset' ranking sorted incorrect for a while, that was the bug to fix
Attachment
Download this attachment
RolandSchubert
16 - Nebula

Re: Challenge #384: Uncover Tennis Stats Upsets!

Spoiler
384.png
Attachment
Download this attachment
ed_hayter
Pulsar

Re: Challenge #384: Uncover Tennis Stats Upsets!

Spoiler
Tennis Time

Challenge 384 WF Image.png

Give us Table Tennis Next!
Attachment
Download this attachment
kmbassett01
Asteroid

Re: Challenge #384: Uncover Tennis Stats Upsets!

Happy Monday! Thanks for the fun challenge Smiley Happy

Attachment
Download this attachment
nSpire
10 - Fireball

Re: Challenge #384: Uncover Tennis Stats Upsets!

Spoiler
384.png
Attachment
Download this attachment
nhardin
Meteor

Re: Challenge #384: Uncover Tennis Stats Upsets!

Spoiler
Solution for challenge # 384Solution for challenge # 384
Attachment
Download this attachment