Can someone help me with the breakdown of the Pearson Correlation Tool ?On opening the deprecated tool of Pearson Correlation, the one for Spearman's Correlation gets open.
Hey @Mario36 How about this:
Using the old tool I did a bit of data prep first and then got the same output as excel:
hi @Mario36 the macro version of the Pearson tool was replaced with a non-macro version. What are you looking for specifically? Right click the palette to Show Deprecated Tools - do you see one or both versions?
If you're looking for the deprecated version specifically, do you see it in this folder (for a standard install)?
C:\Program Files\Alteryx\bin\RuntimeData\Macros\PearsonCorrCoeff.yxmc
Can you navigate to the One Tool Example, either through the Help menu, or clicking on the link in the tool tip?
If I'm missing the point, please give me some more detail (what Alteryx version you're using, etc) and I can check more thoroughly, thanks.
Hi @CristonS ,
I did check the deprecated tools but unfortunately the workflow is not the one of Pearson Correlation and looks like the Spearman Correlation. The Interface Tools are a clear example of the same.
Hey @Mario36
Like @CristonS said the Pearson Correlation tool got updated, so its interface changed. The Deprecated version has a much more similar interface to the spearman correlation tool. But if we compare their effects on the same dataset, we can see that the new and old pearson tools give a different output to the spearman tool.
Sorry if I've misunderstood, but does this help in any way?
Hi @OllieClarke ,
I totally understand what you're explaining but let me point out an issue where Alteryx suffers. I have attached a workflow which explains my issue.
Taking an example of 'Group8', this field has only 5 data point when compared to the other 12 Groups which have 36 data points. The actual Correlation calculation for Group8 across the other 12 Groups should consider only these 5 data points and not 36. What Alteryx does is, it backfills the blank 31 data points with zeroes and considers the 'Number of observations' to be 36 instead of 5.
Within the workflow, the excel data file contains a 'Correlation' tab which gives the actual and desired numbers. Grateful if you could help me achieve this result.
