Hi

Manual deployment of the "correl" function is fine if one only has a few
data sets to compare . In this case I understand you have 40 variable sets
which must
as individual entities, have correlation tests run against every other
set...that in something like 40^2 analysis by my reconing..is that
correct ?

If so thats a lot of typing lol....

If you want code to do this task I would be willing to write it for you :)
I'll need the spread sheet

Bests N10





"Mike Middleton" wrote in message
...
montreal1775 -

The Correlation tool of Excel's Analysis ToolPak provides all pairwise
correlations.

- Mike
http://www.mikemiddleton.com

"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