Is it possible to extract the diagonal elements of a matrix into a vector by using matrix multiplication only? If it is possible show how ;)
I'm curious how long it will take for you guys to answer this. Btw, no element by element multiplication is allowed.
| +102 | People who despise the industry you work for - uncomfortable date story | 60 | 5h |
| +20 | Cardone Capital…..Crashout | 13 | 1d |
| +12 | Trapped With No Way Out | 2 | 10h |
| +8 | Who is your current crush? | 19 | 7m |
| +6 | Things to do in Charlotte before Tame Impala | 3 | 4d |
| +5 | Masters tickets lottery | 4 | 4d |
| +3 | Best Uber Eats Restaurants Toronto | 0 | 5d |
| +3 | For WSO users from NYC: What is your favorite NYC Football team? | 5 | 1d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
={MMULT(horizontal,MMULT(matrix,TRANSPOSE(horizontal))}
This results in a number. The question asks for a column vector with the diagonal elements in it. ;)
Look, I don't know how to do it in excel because I refuse to lower my standards to it, but in general
Ax = b
Take a 2-by-2 matrix A, where a_ij is the ith row and jth column element (i,j =2). Then you want b = [a_11 a_22]^T (T is the transpose). In this case,
Ax = b (A^-1)Ax = (A^-1)b
hence x = (A^-1)b
So matrix A has to be invertible. If you can find the inverse of a matrix using your software, then simply multiply this inverse matrix by the vector of diagonals to get this vector x, which you need to multiply to the vector of diagonals.
That's pretty much the way to do it, but in this case I am not allowed to use any 'find' commands, nor am I able to use any other commands that create a diagonal matrix (all elements besides the diagonal are zero). I am only allowed to use the multiplication of matrices, and am constrained by the number of multiplications I can perform.
Repellat reprehenderit dolorem consequatur rerum blanditiis ullam. Sunt repellendus quibusdam molestiae aperiam in fugiat veniam. Ipsa reiciendis occaecati nostrum. Enim esse accusantium beatae omnis eos et ut magnam.
Quia excepturi numquam sit distinctio et illo. Impedit blanditiis alias autem repellat dolor ipsa suscipit.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...