Linear Regression, slope and intercept

[mmongeon]

Hi,

Here's a macro I built for one of our business users.  

It takes a series of X and Y values as input, performs a least squares linear regression and returns the slope and intercept.

You also have the option of forcing the Intercept to 0, in which case, it will calculate and return the slope.

Hope it can be useful to others.

Enjoy!

[BenMoss]

I'm sure this will be useful!

Make sure you post it on the Alteryx Gallery (https://gallery.alteryx.com/#!), it's a central location for all things public macros/apps.

Ben

[mmongeon]

Thanks!

Posted: Alteryx Analytics Gallery - Least Squares Regression (Slope, Intercept)

[Atabarezz]

great simple solution 🙂

though one may need a multivariate solution so do you have any idea why

we can't force intercept to 0 in linear regression tool?