PCA or MMULT on large array

**lady_Jane** · 06-17-2011, 09:50 AM

Hi everyone,
I am trying to perform a principal components analysis on 1116 records with 10 variables. I am doing this by computing Eigen Values and multiplying them (MMULT) by my 10 standardized variables. Apparently in Excel 2003 (which is what I use) the array for an MMULT function cannot exceed 5000-something cells.
Do you know of a way to perform a PCA on a large array, or to use the MMULT function on a large array?
Would updating my version of Excel work?
Thanks.

**shg** · 06-17-2011, 10:00 AM

Welcome to the forum.

See http://xcell05.free.fr/morefunc/english/

**daddylonglegs** · 06-17-2011, 10:03 AM

The limit in Excel 2003 is 5460 cells for output - in Excel 2007 and later there is no specific limit for MMULT - it's simply limited by available memory

**lady_Jane** · 06-17-2011, 11:46 AM

Thanks shg, that looks like it will do the trick.
The download link from the URL you posted did not work, but I was able to download it from here:
http://download.cnet.com/Morefunc/30...-10423159.html

**lady_Jane** · 06-17-2011, 02:06 PM

It appears I spoke too soon. I downloaded MoreFunc and all I got was a setup file. I had my IT dept. install it, but nothing has shown up in Excel. The function I want to use (mmult.ext()) is returning a NAME? error which I assume means that the function isn't recognized.
Was my download supposed to include a dll file as well?
Thanks.