How to show only significant correlation (>= .6) in a large correlation matrix

helalmob

I have 33 Likert scale variables that measure different types of disabilities from facial expression to speech, etc. The total score across all 33 scores gives a good index of an overall disability level. However, I found out that some items are highly correlated and perhaps redundant. I ran a correlation matrix for the 33 items in JMP Pro 16 that produced a huge table with the majority of correlations >= .5 and some > .5. My question is how to only show > .5, or >= .6 correlation in the matrix? The scatterplot is more visual but need to select only the ones in the red circle and exclude the rest

Thank you,

Mark_Bailey

Click the red triangle at the top of Multivariate and select Pairwise Correlations. This report might be a better layout for you.

 

You can right click in this table and select Sort by Column. I would use p-value so that you do not end up with strong correlations at the top and at the bottom because of negative or positive correlation. You could also right click and select Make Into Data Table, and then create a new column with Abs( corr ) for sorting the whole table.

 

There are other solutions, but hopefully you get the idea.