turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- JMP User Community
- :
- Discussions
- :
- Cluster correlations analysis in JMP?

Topic Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 25, 2017 8:52 AM
(624 views)

Hi Everyone,

I just whatched one of @julian you tube videos, displaying how to make different heatmap correlation plots using jmp.

I am trying to analyze one of my data sets by taking different correlation values, spearman p, pearson, and kendall's t, then clustering the data using different techniques, ward, average, complete linkage etc. The end result is to produce something similar to the photo below made in R studio.

I know there is a cluster off of correlation feature in multivarate, but does anyone know how do you adjust the cluster techque as well as the correlation values used in the cluster analysis?

Analysis produced in R studio

Thanks for your help

Kyle

1 ACCEPTED SOLUTION

Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 27, 2017 7:07 AM
(1070 views)

Solution

Hi @Kyle,

The correlation heat map in Multivariate is based on the Pearson correlation only. If you want to make a heat map of correlations using another statistic (like Tau, or Rho) you'll need to generate a table of correlations like I showed in the video you watched. To do that more quickly you could use an add-in I wrote to automate the process: https://community.jmp.com/t5/JMP-Add-Ins/Correlate-Y-by-X-Add-In/ta-p/23628/

As for changing the clustering technique, you can set the method used when you launch Hierarchical Clustering from Analyze > Clustering in the options section on the lower left side of the launch window. Once you've generated the cluster report, you can request Two-Way clustering from the Red Triangle, which will cluster the variables used in your analysis. Assembling all the pieces together to make the plot you attached will be a somewhat manual process -- my recommendation would be to save each element as an image from JMP and then assemble them in a graphics program (or even Powerpoint).

I hope this helps get you started!

2 REPLIES

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Oct 27, 2017 7:07 AM
(1071 views)

Hi @Kyle,

The correlation heat map in Multivariate is based on the Pearson correlation only. If you want to make a heat map of correlations using another statistic (like Tau, or Rho) you'll need to generate a table of correlations like I showed in the video you watched. To do that more quickly you could use an add-in I wrote to automate the process: https://community.jmp.com/t5/JMP-Add-Ins/Correlate-Y-by-X-Add-In/ta-p/23628/

As for changing the clustering technique, you can set the method used when you launch Hierarchical Clustering from Analyze > Clustering in the options section on the lower left side of the launch window. Once you've generated the cluster report, you can request Two-Way clustering from the Red Triangle, which will cluster the variables used in your analysis. Assembling all the pieces together to make the plot you attached will be a somewhat manual process -- my recommendation would be to save each element as an image from JMP and then assemble them in a graphics program (or even Powerpoint).

I hope this helps get you started!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Get Direct Link
- Email to a Friend
- Report Inappropriate Content

Nov 2, 2017 12:59 PM
(509 views)