Search

Close

Start Free Trial

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

This one was definitely a little more difficult than I expected, but glad I've completed it!

Complete!

Gonna go out on a limb and say this wasn't the most efficient solution.

Challenge Solution

Re: Challenge #3: Running Averages

My Solution.

WOW

This one kicked my butt.

1. I didn't know what a 'running average' was to begin with, I need to go back to math school.

2. The strange acronyms for column names made it difficult to understand what was going on when transposing data.

For a workaround for myself, I renamed the columns with actual words (car brands and some sciency sounding words), and threw in some color-coded table graphics to help me make sense of what the Transpose and Cross Tab tools were doing.

Nick

Spoiler