Correlate Y by X Add-InThis 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 |
|---|
 |  |  |
Data VisualizationUtilitiesRe: Correlate Y by X Add-InHello Julian,
Since this provides the Pearson correlation values/probabilities in columns I would also love to see this add-in updated for the current version(s) of JMP (I am using 16.0.0 and the plugin doesn't work!).
Sincere thanks!
Re: Correlate Y by X Add-InHi Julian,
The add-In doesn't work as before. It had a lot of great features that were not included in the Response Screening such as nonparametric correlations and p-values (Spearman ρ, Kendall τ, Hoeffding D) and the scatterplot. Do you think those features can be back in this Add-In?
Thanks!
Re: Correlate Y by X Add-InHI, when running the addin in JMPGenomics, most result windows pop up (I think 2 or 3) and close immediately automatically. Also in the table with the correlations I cannot open the saved scatterplots and the correlations are not coloured by value. I am using Windows 10. What are the requirements for this tool to run.Re: Correlate Y by X Add-In<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />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!
Re: Correlate Y by X Add-InFun 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.
