View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aaronmsl aaronmsl is offline
external usenet poster
 
Posts: 1
Default Top half of covariance matrix

Hi

So I've used data analysis to produce a covariance matrix, however it only
generates the bottom half of the matrix. Since I want to use the matrix with
an index function, I need both halves of the table. Does anyone know an
automatic way of doing this, or do I need to do each cell manually?

Thanks
Aaron