Thread: [Solved] making correlation matrix
View Single Post
 
Old 03-18-2013, 09:47 AM
Ridgerunner Ridgerunner is offline Windows 7 64bit Office 2003
Novice
 
Join Date: Dec 2011
Posts: 20
Ridgerunner is on a distinguished road
Default correl matrix

So the answer seems to be that there is no longer a built in function in excel that will make a correlation matrix. I looked at that link and can't imagine how I'd ever get a forumula written that would deal with 34 elements over hundreds of samples. I can't tell at all how the formula mrexcel wrote works - no clue. Not a mathematician. The matrices I make in excel2003 are 34x34 and stretch across an 11x17 sheet and it only takes a couple of minutes to make them regardless of how many samples I have.
Reply With Quote