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 hav...