Hey all,
I'm trying to get a significance score along with the pearson correlation I'm running. I couldn't find a way to do it.
Any help is appreciated!
@NeilR has created a macro that parses the report output and brings the data back into lt Alteryx; the original post can be found at this link: http://community.alteryx.com/t5/Advanced-Analytics/Pulling-data-from-Linear-Regression-report-output/m-p/608#U608
I have attached the macro here for ease of use - hope it helps!
The p-values are given in the report output of the associtation analysis tool - for example:
Hey Sean, Thanks for that. I did see the association analysis but it produces a report rather than something I can use within my workflow. (Unless there's a workaround)
If I were to take your example, I want to create a table correlating one variable to multiple variables
Trans
Trans Correlation (pvalue)
MPG Correlation (pvalue)
Cyl Correlation (pvalue)
Disp Correlation (pvalue)
And then use that table to summarize etc further.
Think I could do that with the association analysis? or maybe somehow at least pull the results from the table
