View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
N10 N10 is offline
external usenet poster
 
Posts: 141
Default Iterative Correlation Test


"montreal1775"
wrote in message
news:montreal1775.2c8f04_1155058209.1099@excelforu m-nospam.com...

I was wondering if it is possible to run correlation test over every
possible combination of several variables (around 40) automatically? If
so, could Excel find correlation between individual variables and every
other possible groupings of variables? Each variable has the same
number of rows.

Any help is appreciated!


--
montreal1775
------------------------------------------------------------------------
montreal1775's Profile:
http://www.excelforum.com/member.php...o&userid=36994
View this thread: http://www.excelforum.com/showthread...hreadid=569533


HI Montreal

Do you mean linear regression coefficient or is it some other statistical
measure you are after ? CHi Square ?

Best N10