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:
[TABLE="width: 320"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.27[/TD]
[TD="align: right"]0.46[/TD]
[TD="align: right"]0.51[/TD]
[TD="align: right"]0.56[/TD]
[/TR]
[TR]
[TD="align: right"]0.27[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.42[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD="align: right"]0.46[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.53[/TD]
[/TR]
[TR]
[TD="align: right"]0.51[/TD]
[TD="align: right"]0.42[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.56[/TD]
[/TR]
[TR]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.33[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]1.00[/TD]
[/TR]
</tbody>[/TABLE]
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:
[TABLE="width: 320"]
<colgroup><col span="5"></colgroup><tbody>[TR]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.27[/TD]
[TD="align: right"]0.46[/TD]
[TD="align: right"]0.51[/TD]
[TD="align: right"]0.56[/TD]
[/TR]
[TR]
[TD="align: right"]0.27[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]0.42[/TD]
[TD="align: right"]0.33[/TD]
[/TR]
[TR]
[TD="align: right"]0.46[/TD]
[TD="align: right"]0.47[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.53[/TD]
[/TR]
[TR]
[TD="align: right"]0.51[/TD]
[TD="align: right"]0.42[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]1.00[/TD]
[TD="align: right"]0.56[/TD]
[/TR]
[TR]
[TD="align: right"]0.56[/TD]
[TD="align: right"]0.33[/TD]
[TD="align: right"]0.53[/TD]
[TD="align: right"]0.56[/TD]
[TD="align: right"]1.00[/TD]
[/TR]
</tbody>[/TABLE]