Linear regression

[rcauquil]

Hello All,

I am new to the Alteryx Community and hope to get some useful tips from you ;)

What I am trying to do is analyse consumption data of different articles accros time

I would like to calculate in alteryx y = ax + b for each article and use it as data for further analysis

Input:

Week	Article	Quantity
1	Article 1	5
2	Article 1	8
3	Article 1	11
4	Article 1	14
5	Article 1	17
6	Article 1	20
7	Article 1	23
8	Article 1	26
9	Article 1	29
10	Article 1	32
11	Article 1	35
12	Article 1	38
13	Article 1	41
14	Article 1	44
15	Article 1	47
16	Article 1	50
17	Article 1	53
18	Article 1	56
19	Article 1	59
20	Article 1	62
21	Article 1	65
22	Article 1	68
23	Article 1	71
24	Article 1	74
25	Article 1	77
26	Article 1	80
27	Article 1	83
28	Article 1	86
29	Article 1	89
30	Article 1	92
31	Article 1	95
32	Article 1	98
33	Article 1	101
34	Article 1	104
35	Article 1	107
36	Article 1	110
37	Article 1	113
38	Article 1	116
39	Article 1	119
40	Article 1	122
41	Article 1	125
42	Article 1	128
43	Article 1	131
44	Article 1	134
45	Article 1	137
46	Article 1	140
47	Article 1	143
48	Article 1	146
49	Article 1	149
50	Article 1	152
51	Article 1	155
52	Article 1	158
1	Article 2	158
2	Article 2	155
3	Article 2	152
4	Article 2	149
5	Article 2	146
6	Article 2	143
7	Article 2	140
8	Article 2	137
9	Article 2	134
10	Article 2	131
11	Article 2	128
12	Article 2	125
13	Article 2	122
14	Article 2	119
15	Article 2	116
16	Article 2	113
17	Article 2	110
18	Article 2	107
19	Article 2	104
20	Article 2	101
21	Article 2	98
22	Article 2	95
23	Article 2	92
24	Article 2	89
25	Article 2	86
26	Article 2	83
27	Article 2	80
28	Article 2	77
29	Article 2	74
30	Article 2	71
31	Article 2	68
32	Article 2	65
33	Article 2	62
34	Article 2	59
35	Article 2	56
36	Article 2	53
37	Article 2	50
38	Article 2	47
39	Article 2	44
40	Article 2	41
41	Article 2	38
42	Article 2	35
43	Article 2	32
44	Article 2	29
45	Article 2	26
46	Article 2	23
47	Article 2	20
48	Article 2	17
49	Article 2	14
50	Article 2	11
51	Article 2	8
52	Article 2	5

Target Output:

Article	a	b	r²
Article 1	3	2	1
Article 2	3	161	1

Do you know if there is a quick way to do this without having to go through lengthy calculations?

Thanks!

[jdunkerley79 · Accepted solution]

You could use the predictive tools but think you would need to batch macro it to make it run group by group.

I attach a macro implementing Linear Regression using Summarize Tool and Formula Tool (Slope and Intercept are easy enough, RSq is a bit horrific)

Nice thing is it is blisteringly fast as all native core Alteryx tools

[JoBen · Accepted solution]

Hey @rcauquil, I see that @jdunkerley79 already provided something similar, but here is a macro with some R script that does these computations. Hope this helps :). 

[rcauquil]

Thank you so much @jdunkerley79 

You just saved me a lot of hours! works perfectly

[rcauquil]

Hey @JoBen - works great!

[vivaisun11]

Hey there,

I'm on Alteryx v11.7 and in need of this worfklow. The one that you attached requires a newer version.

Can you please explain how you went about doing this? Thank you. 🙂