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.
|