Challenge #229: Trend Analysis

[AYXAcademy]

A solution to last week’s challenge can be found here. 

This week's challenge was submitted by @wwatson  - Thanks for your submission!

Two sets of performance data are provided below. Plot that data on bar charts, calculate a trendline for each graph, and export the charts to a single Powerpoint slide.

The method for calculating the trend line can be found on various websites. The author used this one.

[Aaron_Harter]

Not your average challenge!

Spoiler

(edit 8/17 9:53 CT) video of solution overview:

Spoiler

The trend line calculation was driven by the core logic from this Macro in the gallery - https://gallery.alteryx.com/#!app/Least-Squares-Regression--Slope--Intercept-/5ab4ff0f8a9337138c471a...

[dsmdavid]

Not Base Alteryx compliant, but...

Spoiler

[johnemery]

Fun challenge. A good one, too, for those who aren't well-versed in linear regression: this is how it's done!

But tisk tisk tisk; shame on you Alteryx for truncating the y-axes on your output charts.

Spoiler

 Check out my solution video below:

Spoiler

[Blake]

229 done!

Spoiler

[atcodedog05]

@Aaron_Harter Great to know about the macro.

[wwatson]

Extra points for those not using the macro though 🙂

[atcodedog05]

Was a great exposure : )

Thank you for this great challenge @wwatson 

I followed the steps from the website given in the challenge description.

Spoiler

Cheers and Happy analyzing : )

[patrick_digan]

Spoiler

[jasperlch]

Spoiler