matrix operations

Hi all Is there an extensive add-in for VBA/excel for matrix and vector operations? In other words, an add-in with a selection of matlab or R functions? Regards Tunc

I am trying to calculate a covariance matrix in VBA. I have managed to get my data into an array "datarng" which has 10 columns and 100 rows. I want to calculate the covariance matrix of my dataset so that I will have a new array 10x10 by calculating the covariance between each column in the...

Hello everybody! I am having a problem in running an operation using two columns. For simplicity, lets say that the two columns are: column1 column2 1 -----------3 2 -----------5 And I want to fill in another column the sum (or product, or any other operation), each possible combination of the...

Hi, Can anyone tell me how to make a matrix from an array? My problem is the following: My data looks like: X1 X2 X3 X4 1 2% 3% 4% 2 1% 4% 8% 3 9% 2% 3% .. 40 1% 2% 1% So my array looks like: array(1 to 40, 1 to 3) Where array(2,1) = 1%, array(2,2) = 4%, array(2,3) = 8% Now how can I...