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 Challenge_498_start_file.yxzp Challenge_498_solution_file.yxzp

I couldn't get this to match with the provided solution, but also I'm not sure I followed the same path... Considering my average of those categories couldn't be over 5... Still a fun puzzle to solve.. Curious what I misinterpreted from the instructions that led me to such a different result. Let me know if you see this and figure it out! Maybe I will compare another day. Challenge 498 Solution.yxmd

Complete!! Spoiler Challenge498_CK.yxmd

Challenge Completed Spoiler Challenge_498_Joe_Serpis.yxzp

Challenge #498: Not Your Average Mario Kart

AYXAcademy

Full Width - WC banner.svg

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

Challenge_498_start_file.yxzp

Challenge_498_solution_file.yxzp

Macros

Advanced

Intermediate

Transform

Accepted answers

All comments

Bobbyt23

A really fun challenge, will be unstoppable at Mario Kart thanks to data!

Spoiler

Weekly Challenge 498 17-12-25.yxzp

RolandSchubert

Spoiler

challenge 498_solution_rsc.yxzp

alacoume

My solution:

Spoiler

Challenge 498_start_file.yxmd

Kenda

Spoiler

Can't wait to go home and challenge my husband to a Mario Kart competition now!

498 kenda.yxzp

Hub119

Instruction #2 should probably say determine the aggregate (aka SUM) stat value for each combination...

Spoiler

Challenge 498 - CH Solved.yxzp

olga_strubbe

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.

Spoiler

Weekly Challenge 498_OS.yxmd

chanivan

Diddy Kong + Mr. Scooty is the best combo 😀

Spoiler

Challenge 498_start_file_ic.yxmd

EKasminsky

Spoiler

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!

Challenge 498 EK.yxmd

jrlindem

Here's my solution. Took me longer than I'd like to admit, but I got there 😅

Thank you @Erin for the fun challenge. I told my boys about it and they didn't believe me that I was having fun with Mario Kart data!

Spoiler

Challenge+498_jrlindem_solution.yxzp

Pilsner

Love a bit of Mario Kart! I probably could have looked for a method which involved a few less pivots, but it's all good practice.

Spoiler

Workflow:

498 (Mario Kart).yxzp

balajilolla3

Spoiler

Solution Attached

Challenge 498_start_file.yxmd

Qiu

I think this is the first time that Weekly challenge has to run for 1 minute?

I made two versions for with and without a standard macro.

Spoiler

Challenge 498_start_file_Qiu.yxzp

Nicholas_14

Interesting challenge with exposure to many tools. Using appends it's easy to lose track of data due to data inflation. However when you have some placeholder in place to keep track of grouped records it becomes smoother.