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!
Solved! Go to Solution.
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.
OK - thanks! Let me try this! I just got sidetracked so I'll come back to this as soon as possible...