Storing variables based on p-value

Hello, I'm new to alteryx. I need help storing variables from the linear regression I am running with p-values less than 0.05.

What i'm trying to do is similar to this thread (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Pulling-data-from-Linear-Regression-report-output/td-p/608) but I only want variables with less than 0.05 p-value.

I tried tweaking Dr.Dan's code hy adding "[which(mod.obj$coefficients[, 4] <0.05)]" after mod.obj$coefficients but I realized it wasn't the regression summary table it was calling so column 4 does not exist. How can I specify what variables to store based on p-value?

Output

Best Practices

Predictive Analysis

R Tool

Accepted answers

joshuaburkhow

So it sounds like you might be trying to widdle down the number of variables in your model? If so there is the Stepwise tool that does that....

Screen Shot 2019-09-25 at 11.46.01 PM.png

All comments

joshuaburkhow

Unfortunately I am having some issues with some of the macros on my machine so I can't test/build an example for you but did you try the "Model Coefficients" tool that @chris_love and @DrDan mentioned in that post?

kristinecp

Yes, I was able to extract the variables and coefficients using Dr. Dan's macro but some of the variables pulled out had p-values greater than 0.05. I was hoping to have some control over which variables were extracted and select only those with less than 0.05 alpha. But thanks, anyway!

Quick Links

This months top contributors

mceleavey 383

AkimasaKajitani 382

mbarone 337

Hollingsworth 335

LanisC 335