Challenge #3: Running Averages

[Bluemoon]

Completed as a POC, couldn't be bothered to repeat for all categories...

Spoiler

[jusdespommes]

I'm sure there's a prettier solution - but here's mine 🙂

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Jonathan-Sherman]

Challenge 3 is done!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[danuliatko]

This one was more challenging, but managed to get the result

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ericlaug]

Like Bluemoon's, my solution is more of a POC. As @SeanAdams pointed out the error in calculating some of the initial averages, I found I needed to count the rows and their sums separately and then use a simple formula to compute the row's running average. I do like his use of the transpose and crosstab tools.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[timrains]

Tricky one. All done. 

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[jaiswas1]

Attaching the solution approach that I have taken to solve this challenge.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[AMansour]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[kmbutterfield]

First evert Intermediate Challenge 🙂

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[BSilverblatt]

Thanks for the challenge! This is my solution.

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.