i have data in 2 columns.....
in the range c7 to d.....
the number of rows of data keep on changing as i change my stock.....
now i want ....a macro to the following :
take the matrix X ie data from C7 to wherever it ends.....
and do the foll matrix multiplication calc,.......
X * (X'X)inverse * X'
where X' is transpsoe of X .......
pls help....
sam
in the range c7 to d.....
the number of rows of data keep on changing as i change my stock.....
now i want ....a macro to the following :
take the matrix X ie data from C7 to wherever it ends.....
and do the foll matrix multiplication calc,.......
X * (X'X)inverse * X'
where X' is transpsoe of X .......
pls help....
sam