Subscribe Bookmark RSS Feed
julian

Staff

Joined:

Jun 25, 2014

Correlate Y by X Add-In

This add-in generates a table of correlations and p-values from specified Y against the specified X columns. By default the resulting table includes parametric and nonparametric correlations and p-values (including FDR corrected p-values), as well as scatterplot images and a heatmap script saved to the table. If saved, the column of scatterplot images is marked as a label column and hovering over points in the heatmap will reveal the scatterplot. Unlike saving a table of correlations from Analyze > Multivariate Methods > Multivariate, this add-In produces correlations for just the specified Y columns against the specified X columns (rather than all Y against each-other).

Options:

  • Save Scatterplot Images to Table (on by default - requires JMP 12): saves images of each scatterplot including density ellipse to data table as an expression column. Note: this can be time consuming for a large number of variables.
  • Nonparametric Correlations (on by default): saves nonparametric correlations and p-values to table (Spearman ρ, Kendall τ, Hoeffding D).
  • False Discovery Rate Correction (on by default): applies the Benjamini-Hochberg adjustment to p-values (including non-parametric p-values if requested)
  • Color Cells by Correlation (on by default): colors individual cells by the value of the correlation.
  • Sorting (off by default): If a sort option is selected, resulting data table will be automatically sorted by the Pearson correlation (descending) or p-value (ascending).

Dialog

Specify Numeric Y and X

Data Table with Scatterplot Images

and Saved Heatmap Script

Heat Map with

Scatterplot Mouse Over

11535_Screen Shot 2016-05-12 at 10.31.43 AM.png11536_Screen Shot 2016-05-12 at 10.33.09 AM.png11517_GbHeat.gif
Comments

Fun script, I am going to try it out on a historical data project. Just a note, when I ran on JMP12 (mac) the colors did not automatically save to my table nor did the script for the heat map.

julian

Well that's no good! It's working on my instance of JMP 12 on my mac but I'll try it on some others machines to see if I can track down what is going on. Thanks for letting me know!