Quick way to populate many correlation coefficients in to a column at once?I have a dataset with five sample dose levels and many compound concentrations identified in the samples. I would like to see which of the compounds correlate with the sample levels and sort the compounds by most correlated. I think the easiest way would be to batch-run regressions and have the Pearson correlation coefficient or r squared populate to a data table, but I'm not sure how. Would I have to write a script or is there a different way?
I'm using JMP pro 16.
Thanks!
Automation and ScriptingBasic Data Analysis and ModelingWindows