topic Re: Plotting Correlations using tall vs wide datasets in Discussions

Plotting Correlations using tall vs wide datasets

ndowidar — Tue, 11 Mar 2025 18:28:59 GMT

I have duplicate measurements that I'd like to plot against each other to check for outliers. My problem is that I have two instances of the same data. So I've labeled one set A & the other B for given metric. In JMP, I can't seem to plot A vs B because they're in the same column. Do I have to label each metric with an A or B to plot them against each other?
As an example I attached a simplified dataset. I'd like to make a correlation plot between Set A vs B using a correlation of coverage between the the two.
Thanks so much!

Re: Plotting Correlations using tall vs wide datasets

txnelson — Tue, 11 Mar 2025 21:37:33 GMT

Split the data table

Tables=>Split

Split on Set

Split Columns on Reads and Coverage

Grouping on ID

Then you can easily correlate on the 2 columns created for reads and coverage

Look at Response Screening to get your correlations in a data table format

Analyze=>Screening=>Response Screening