View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default multiple correlations with one click?

I know what a correlation is but I have no idea what you want. Define
"correlation" in your context. IOW, what do you want to see as the result?
HTH Otto

"bondjel" wrote in message
...
I have a numerical data set with 11 columns and 1809 rows. I would like to
simply obtain a table of correlations involving Col 1 with each remaining
Col (Col 2 thru Col 11), then Col 2 with each remaining Col (3 thru 11),
then
Col 4 with each remaining Col (5 thru 11), and so on until the last
correlation, i.e., Col 10 with Col 11.