Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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 #430: Inspire 2024 – Grand Prix (Lap 3)

AYXAcademy
Alteryx
Alteryx

Inspire_Training_Banner_3337x600.png

Hi Maveryx,

 

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

 

Welcome to the third and final lap of our Weekly Challenge based on the Inspire 2024 Grand Prix! As we reach the climax of this thrilling journey, we are excited to present a challenge on predictive analysis. This topic, not often featured in Weekly Challenges, promises to push the boundaries of creativity. Get ready to dive deep and showcase your predictive analytics expertise!

 

Your task is to build a model to predict the top three podium finishers and compare the predicted versus the actual Silverstone podium finishers, and then identify the predicted racer who was not an actual podium finisher.

 

Use only driver race averages for full races, not qualifiers in Japan, Qatar, and Qatar Sprint to train the model. Use the model you built to score any drivers with full race data from Silverstone and determine the three most likely podium finishers. Then, identify any of those three drivers who did not actually make the podium at Silverstone.

 

Minimum lap counts per race to determine full race data:

  • Japan: 53
  • Qatar: 57
  • Qatar Sprint: 19
  • Silverstone: 52

 

The tasks to accomplish your objective include:

 

  1. Create a training dataset using the Race Data Japan_Qat_Quali_Sprint dataset for your model. Be sure to exclude qualifying races and drivers who did not complete a full race using the minimum lap counts above.
  2. Using this training dataset, build a Logistic Regression to estimate the likelihood a driver will finish in the top three on the podium.
    1. Use any Avg variables as possible predictors and nothing else.
    2. Use a Stepwise tool with the default configuration to determine the best predictor variables. The Stepwise tool will automatically determine the final model variables for the model.
  3. Score any Silverstone drivers with full race data using the Stepwise output and identify the top three most likely podium finishers.
  4. Compare the predicted podium finishers versus the actual Silverstone podium finishers. Find the predicted driver who did not finish on the actual podium.

 

Feel free to use the hints provided within the workflow.

 

Need a refresher? Review the following lessons in Academy to gear up.

 

Good luck!

 

AYX-Maveryx_Micro Identity-Maveryx Academy_wordmark.png

ahsanaali
11 - Bolide
Spoiler
430.png


If you skip PitStopAvg predictor variable, then predictions are 100% accurate. How do I know that....well that's what I missed initially and spent good 10 mins finding why prediction were 100% accurate :-).

 

ggruccio
ACE Emeritus
ACE Emeritus

Solved it!  Sorted on the score for "Yes".

 

Spoiler
430.png
mmontgomery
11 - Bolide

C430

Spoiler
I made lots of small mistakes, but I eventually got it in 9 minutes
c430.png
AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
Today, I misunderstood very much. So it took too much time. In other words, the predicted results show very little difference between all the racers.
スクリーンショット 2024-06-25 001054.png

aatalai
14 - Magnetar

More predictive  challenges please 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
430.jpg
ed_hayter
12 - Quasar
Spoiler
image.png

good refresher on predictive
Qiu
21 - Polaris
21 - Polaris

This will take me a while. 😁

estherb47
15 - Aurora
15 - Aurora

Fun predictive exercise!