Calculating Spearman's Rho Value Matrix for 6x6 Matrix

  • Context: Undergrad 
  • Thread starter Thread starter swartzism
  • Start date Start date
  • Tags Tags
    Value
Click For Summary

Discussion Overview

The discussion revolves around calculating the Spearman correlation matrix for a 6x6 matrix derived from a larger 15x6 dataset. Participants explore methods for generating this matrix and clarify the nature of the correlation being calculated, with references to a specific white paper.

Discussion Character

  • Technical explanation
  • Debate/contested
  • Exploratory

Main Points Raised

  • One participant expresses confusion about calculating the Spearman correlation matrix, noting that existing examples only cover two columns.
  • Another participant suggests referencing publicly available materials and mentions the "Iman and Conover" method as a potential resource.
  • A later reply provides a publicly accessible version of a document that contains the relevant matrix, directing attention to a specific page.
  • It is clarified that the 15x6 matrix consists of sample data representing 15 joint realizations of 6 random variables, leading to a naturally 6x6 correlation matrix.
  • One participant discovers that the matrix they were attempting to replicate is not a Spearman correlation matrix, but rather the Pearson correlation matrix of the original dataset, correcting their earlier misunderstanding.

Areas of Agreement / Disagreement

Participants do not reach a consensus on the nature of the correlation matrix being discussed, with some asserting it is Spearman's while one participant claims it is actually Pearson's. The discussion remains unresolved regarding the correct interpretation of the matrix.

Contextual Notes

There are limitations regarding the clarity of the correlation methods discussed, as well as the potential for confusion between Spearman and Pearson correlations. The specific calculations and assumptions made by participants are not fully detailed.

swartzism
Messages
103
Reaction score
0
So I'm interested in calculating the Spearman correlation matrix, but I am running into some issues. All of the examples I have found only calculate rho scores between two columns. I am trying to replicate results from a white paper (http://www.tandfonline.com/doi/abs/10.1080/03610918208812265?journalCode=lssp20) and they generate a 6x6 correlation matrix T for a 15x6 matrix R. I cannot figure out how they do this!

I know how to calculate Pearson's correlation coefficient in matrix form by performing R'*R and working on the resultant 6x6 matrix, but Spearman's doesn't seem clear how to produce this T matrix.

Any help on how I would go about generating this Spearman rank correlation matrix would be greatly appreciated!
 
Physics news on Phys.org
The 15 x 6 matrix is matrix of sample data for 15 joint realizations of 6 random variables. The sample correlation matrix for 6 random variables is naturally 6 by 6.
 
I've also discovered that this is not a Spearman's rank correlation, although they claim it is. If you do the the Spearman's coefficient calculation between columns, you do not get the T matrix given. It is in fact the Pearson's coefficient matrix of R! I had a bug in my correlation calculation. I am now getting

1.00000 0.00000 0.00000 0.00000 0.00000 0.00000
0.09688 1.00000 0.00000 0.00000 0.00000 0.00000
-0.46671 -0.31292 1.00000 0.00000 0.00000 0.00000
-0.23352 0.07098 0.33767 1.00000 0.00000 0.00000
0.26142 0.48383 -0.19696 -0.04125 1.00000 0.00000
0.17479 -0.22700 0.19021 -0.02984 0.05223 1.00000

As expected.
 

Similar threads

  • · Replies 2 ·
Replies
2
Views
2K
  • · Replies 14 ·
Replies
14
Views
4K
  • · Replies 2 ·
Replies
2
Views
1K
  • · Replies 7 ·
Replies
7
Views
3K
  • · Replies 1 ·
Replies
1
Views
7K
  • · Replies 1 ·
Replies
1
Views
6K
  • · Replies 1 ·
Replies
1
Views
1K
  • · Replies 3 ·
Replies
3
Views
4K
  • · Replies 2 ·
Replies
2
Views
4K
  • · Replies 0 ·
Replies
0
Views
3K