Regression Modeling

[CraigHarris02]

Hi:

I am brand new to Alteryx and am not sure how would I attempt doing this please...

I want to determine, by store type, which demographic variables are statistically significant to sales. I have a customer file by store, store type (A, B, C), customer sales and demographic variables. How would I go about filtering the data by store type and then run regression analysis ("x" = demographic variable with "y" being sales) on each individual demographic variable in the file, getting it's R-square? I would repeat this process for each of the store types.

Thanks!

[CharlieS · Accepted solution]

Hi @CraigHarris02 

The core analysis here can be performed by the Linear Regression tool. Do you have the Predictive tools (R-based) installed in your Alteryx Designer installation? They're a separate install that sometimes get missed.

https://help.alteryx.com/current/designer/linear-regression-tool 

https://community.alteryx.com/t5/Alteryx-Designer/Tool-Mastery-Linear-Regression/ta-p/35464 

For an example in Alteryx Designer go to: Help > Sample Workflows > Predictive tool samples > Predictive Analytics > 8 Linear Regression

To specify three different models, you could either filter the sample and use three different tools, or use a batch macro. There's a lot we can dive into here, but let's get started by getting the tools working. 

[CraigHarris02]

OK - thanks!  Let me try this! I just got sidetracked so I'll come back to this as soon as possible...