Subscribe Bookmark RSS Feed

Consider only certain combinations when doing Multivariate Analysis

smueller

Community Member

Joined:

Mar 18, 2013

Hi all

I have data for four different variables: A, B, C and D. Now I want to do a Multivariate Analysis using the following steps in JMP: Analyze --> Multivariate Methods --> Multivariate. Then I select my four variables and add it as Y, Columns. After that, I choose Spearman's p in the nonparametric correlations menu. Now I see the correlations between all 4 variables.

Now my problem is that I would like to limit the number of correlations that I see. I want only to see the correlations between A and C, A and D and also between B and C, respectively B and D. I can't find any option for this. Is there any way how to achieve that?

Regards

SM

1 REPLY
Jeff_Perkinson

Community Manager

Joined:

Jun 23, 2011

Hi SM,

There is no option in the Multivariate platform to perform a subset of the correlations as you describe.

However, you can use the Fit Y by X platform to get the pairs that you're looking for. However, since you're looking for Spearman's ρ, you'll need to use the ranks of the actual values in Fit Y by X platform.

Here's an example using the Decathlon data from JMP's Sample Data Library (Help->Sample Data, then look in the Multivariate section).

Here's the first part of the Decathlon data.

4010_JMPScreenSnapz007.png

If I want the non-parametric correlations between Score and Long Jump, Score and Shot Put, 100m and Long Jump and 100m and Shot Put then first I need the rank of each row for each of those columns. This is easy to do using the Distribution platform.

Launch the platform with these four columns in the Y role.

4011_JMPScreenSnapz008.png

Then, hold down the Ctrl key (Command key on the Mac) as you choose Save->Ranks Averaged from the red triangle menu at the top of any of the histograms.

4012_JMPScreenSnapz009.png

It's important to hold the Ctrl key to "broadcast" that menu choice to all of the column in the analysis.

You'll get four new columns in your data table.

4013_JMPScreenSnapz010.png

Use these new columns in Fit Y by X.

4014_JMPScreenSnapz011.png

You'll get a report window with each Y against each X (four in total for this case).

4015_JMPScreenSnapz012.png

Again, hold down the Ctrl key as you choose Density Ellipse->0.95 in the red triangle menu above any scatterplot.

4016_JMPScreenSnapz013.png

You'll get a Correlation report below each scatterplot. The Correlation and Signif. Prob columns in this report are Spearman's ρ and it's p-value for that pair.

4017_JMPScreenSnapz014.png

If you would like a data table of all of these values for all the pairs in the report, you can right click on the report table and choose "Make Combined Data Table" from the menu.

4018_JMPScreenSnapz015.png

You'll get a data table like this.

4019_JMPScreenSnapz016.png

I hope that helps. Let us know if you have any further questions or difficulties.

-Jeff

-Jeff