View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to create a correlation matrix in excel?

How are you defining a set

"Eric" wrote:

There are 26 column of data starting from A to Z for 100 rows. I would like
to create a correlation matrix to show all combinations of 2 sets. Does
anyone have any suggestion on how to create a correlation matrix in excel?
Thanks in advance for any suggestions
Eric