matrix operations

  1. tuncalik

    Is there a VBA add-in for 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
  2. C

    calculating covariance matrix from array in vba

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

    simple question doing operations with two columns

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

    How can I make a matrix from an array

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

Some videos you may like

This Week's Hot Topics