I am looking to get the standard deviation of each correlation coefficient in a matrix.
The matrix is complete (as in each pairwise correlation in included twice) but i want the standard deviation including only each coefficient once.
The matrix will vary in size and can be quite large so i dont want to have to select the cells i need manually. Is there a way to do this?
As an example with the below matrix i would want the std dev of only the underlined values:
<colgroup><col span="5"></colgroup><tbody>
</tbody>
The matrix is complete (as in each pairwise correlation in included twice) but i want the standard deviation including only each coefficient once.
The matrix will vary in size and can be quite large so i dont want to have to select the cells i need manually. Is there a way to do this?
As an example with the below matrix i would want the std dev of only the underlined values:
1.00 | 0.27 | 0.46 | 0.51 | 0.56 |
0.27 | 1.00 | 0.47 | 0.42 | 0.33 |
0.46 | 0.47 | 1.00 | 0.56 | 0.53 |
0.51 | 0.42 | 0.56 | 1.00 | 0.56 |
0.56 | 0.33 | 0.53 | 0.56 | 1.00 |
<colgroup><col span="5"></colgroup><tbody>
</tbody>