software

I am trying to match a calculation.

The calculation is

Matrix1[8 x 8] * Matrix2[8x1] = Matrix3[1 x 8]

Where Matrix[ rows x columns ]

I have the values for Matrix1 and Matrix3, so I need to solve for Matrix2.
Does anyone know how to do this using the matrix functions in excel, I was
having a hard time.

Thanks for your help

Matrix 3 will be an 8×1 matrix, not a 1×8 matrix.
Multiply both sides on the left by the inverse of matrix 1. Use MINVERSE.

quot;Jeffquot; wrote:

gt; I am trying to match a calculation.
gt;
gt; The calculation is
gt;
gt; Matrix1[8 x 8] * Matrix2[8x1] = Matrix3[1 x 8]
gt;
gt; Where Matrix[ rows x columns ]
gt;
gt; I have the values for Matrix1 and Matrix3, so I need to solve for Matrix2.
gt; Does anyone know how to do this using the matrix functions in excel, I was
gt; having a hard time.
gt;
gt; Thanks for your help