Macro or Tool to provide ANOVA?

[davidrioux]

Hello:  While Alteryx' R Tools for linear regression and test of means can provide similar functionality to ANOVA, a macro or tool providing ANOVA functionality would be very convenient to simply look for factors associated with significant differences in a variable of interest.  Setting up indicator variables to enter factors into a linear regression and working through stepwise is not as convenient.  Does anyone have any pointers?  Thanks in advance.

[MichaelF · Accepted solution]

Hi Dave,

Both the Linear Regression Tool and Stepwise Tool reports Type II ANOVA as an output based the model you feed it. If you would like other types, or would like to specify other parameters based on R capabilities (here), you can open the macros for each tool and customize the R Tool in the R code where it's mentioned:

 

Cheers,

Mike