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
Hi Community members,
A solution to last week’s challenge can be found here.
This challenge was submitted by Erin Miller. Thank you, @Erin , for another great challenge!
According to Erin, someone who wins at Mario Kart seems to know every shortcut and trick, and it’s easy to assume they’re always choosing the perfect character and kart combo. But not anymore! We now have access to in-game data for every driver, kart/body, tire, and glider in Mario Kart 8 Deluxe.
Using the datasets provided, the mission is to identify the most optimal combinations that deliver the best overall racing performance.
What You Need to Do
- Compute the average value for each stat category (speed, acceleration, handling, etc.) across each individual dimension: driver, kart/body, tire, and glider.
- Determine the average stat values for every combination of driver, kart/body, tire, and glider.
For example: What is the average speed for a specific driver when paired with a given kart, tire, and glider?
- For each combination, calculate a total weighted average using the provided weights table (or create your own!) to reflect the relative importance of each stat.
The final output should include each driver–kart–tire–glider combination, the corresponding average stat values, and a total weighted score.
Feeling a Little “Extra”?
Use a macro to automate repetitive tasks (such as calculating averages).
Once you have completed your challenge, include your solution file and a screenshot of your workflow as attachments to your comment.
Good Luck!
The Academy Team
Source: https://www.kaggle.com/datasets/marlowspringmeier/mario-kart-8-deluxe-ingame-statistics
Download Start File
Thank you, @Erin for the neat challenge! It was fun.
Thank you, @RolandSchubert for showing a way to use the Arrange tool - I've not used it in a while, it was a good refresher, and it worked perfect in this use case.
Bit of a goofy problem, but fun I guess. Mini Turbo is actually the most important stat in the game! Technically it should be weighted differently for the problem and actually calculated completely separate from Acceleration!
