Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #229: Trend Analysis

rmassambane
10 - Fireball

=D

Neetu
8 - Asteroid

my solution 🙂

Spoiler
229.png
Kirsten_Aleman
6 - Meteoroid
Spoiler
alteyrx challenge screenshot.PNG

This was a lot of fun. Learned some cool tools.

SeanAdams
17 - Castor
17 - Castor

MAN - it's been so long since I've done trend-line and correlation math - this was good.   More of these kinds of challenges would be great!

 

Result1.png

 

Spoiler

Build the trend-line into a macro

Solution1.pngSolution2.png

 

danicahui
8 - Asteroid
Spoiler
Challenge 229 2020-11-09.jpg
dombaikamilla
8 - Asteroid
Spoiler
229.PNG

 

Spoiler
229_ppt.PNG
JosephSerpis
17 - Castor
17 - Castor

Challenge completed 

 

Spoiler
Weekly_Challenge_229.JPG
robert-headington
8 - Asteroid

I created a trend line calculation macro for this which could be useful for me in the future so that is great.

 

I didn't truncate the axis as it is bad practice to truncate bar charts.

jamielaird
14 - Magnetar

Here's my solution:

 

Spoiler
jamielaird_0-1613930020583.pngjamielaird_1-1613930024278.png

 

 

jlies
5 - Atom

Done. Good challenge...