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 #3: Running Averages

danlsn
メテオール

Solved!

AndrewHoData
アステロイド

I don't necessarily agree with the way the expected output is presented as it is difficult to tell which values are the 3 month rolling average or 6 month rolling average. Alas, I got pretty close to the expected output, but not quite the same.

 

スポイラ
AndrewHoData_0-1665636145767.png

 

LukeD
メテオロイド

Hi,

Please find attached my solution for challenge # 3

Kinga
アステロイド

hi,

 

Below my solution

 

スポイラ
I understand what we should learn with this challenge. However, if I would use such "running average at work" as in the example, I would probably have to correct this for the final version. That's why I've added second version of solution this slightly different results.

Kinga_0-1666001083311.png

 

ivan_duniak30079
アステロイド
スポイラ
スポイラ
Spoiler!ivan_duniak30079_0-1666098749250.png

 

martinding
パルサー

The structure of the final output is difficult to read and interpret: I couldn't tell which numbers were 3mo.and which were 6mo. running avg. To make things easier to read, I kept the running averages as separate columns.

TungThanhHo
アステロイド

my solution

Flo_P
アステロイド

Solved it the way I understood the challenge.

benjimoser
コメット

Solved it a bit different than in the solution.

eraaz_lala
アステロイド

Hello,

Pls find attached solution to Challenge # 3. Thanks.