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.