Serving the Quantitative Finance Community

 
User avatar
Shagbag
Topic Author
Posts: 0
Joined: February 5th, 2008, 2:30 pm

Matrix algebra question

March 8th, 2008, 7:53 am

How do I multiply two n x 1 column vectors together so that I get an n x 1 column vector of their dot products?
 
User avatar
msperlin
Posts: 5
Joined: July 10th, 2006, 6:21 pm

Matrix algebra question

March 8th, 2008, 9:40 am

QuoteOriginally posted by: ShagbagHow do I multiply two n x 1 column vectors together so that I get an n x 1 column vector of their dot products?If x is a nX1 column vector, take the diagonal of x*x'.
 
User avatar
Shagbag
Topic Author
Posts: 0
Joined: February 5th, 2008, 2:30 pm

Matrix algebra question

March 8th, 2008, 12:47 pm

Thank you. Do you know if there is a function in Microsoft Excel that does this or do I have to resort to VBA code to do it?
 
User avatar
msperlin
Posts: 5
Joined: July 10th, 2006, 6:21 pm

Matrix algebra question

March 8th, 2008, 12:53 pm

QuoteOriginally posted by: ShagbagThank you. Do you know if there is a function in Microsoft Excel that does this or do I have to resort to VBA code to do it?I don't know if there is a function for it. I use excel just for tables. BUt this should be a simple code at vba.
Last edited by msperlin on March 7th, 2008, 11:00 pm, edited 1 time in total.
 
User avatar
Shagbag
Topic Author
Posts: 0
Joined: February 5th, 2008, 2:30 pm

Matrix algebra question

March 8th, 2008, 1:35 pm

Thanks again. I think I will have to code some VBA.