That sounds like something you need a statistics package for.

"montreal1775" wrote:


I was wondering if there is a way to get excel to run correlation test
between every combination of 37 or 38 independent variable. I need to
find the best way to reduce multicollinearity, and finding every
possible correlation would give me the best idea of which direction to
take. I know the actual computation would take quite a while, but the
computer that would run the tests is very fast, so even 38! runs
shouldn't take very long.

I was also wondering if there was a way to find correlation between one
independent variable and every possible combination of the others,
although this would take much more computing time and might not even
be necessary.

Any guidance is appreciated!


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