Hello,
I have set up a data table, x, in a worksheet. In another worksheet, I have added a transpose, x', of the the x data table. The transpose was done with {=TRANSPOSE(PCA_data!W2:BM2019)}. On the same worksheet, I have set up a matrix that is the product of x'x. This was done with {=MMULT(B52:BYQ94,PCA_data!W2:BM2019)}. Also on the second worksheet, I have taken the determinant of the x'x matrix.
What I would like to automate is the sequential removal of rows from the original data table x while recording the change in the determinant. The data table x has one less row than the total amount of data. Presently, I have one row left out of the matrix calculations. If I manually remove another row with cut and paste it down at the bottom and then manually take the current left out row and return it to x, I get a change in the determinant that I can record. What I need to do is to loop through all the rows in x removing a row and replacing the row that was set aside last. After each removal/replacement exchange I need to record the determinant difference.
I am probably making this seem more complicated that it really is. Suggestions or links to sample code would be appreciated.
LMHmedchem
Bookmarks