View Single Post
  #1   Report Post  
Michael Cantinotti
 
Posts: n/a
Default Recreate the upper part of a symetric data matrix 75x75

hi,

I have to use a matrix that come from SPSS. I get a 75x75 symetric
matrix of distances between points (75 points). Zero are in the
diagonal. Only the lower part of the diagonal is diplayed. I exported
this matrix in Excel.

I am trying to recreate the full matrix (I need this for special
calculus). Is there a way to automate this (I would like to avoid
copy-past transpose, in order to avoid errors) ?

Point X12 should have the same value of X21, same applies for X13 and
X31, etc.

Any idea ? Thks,

Michael