how do i square matrices?
sparkskey wrote:
hello!!!how do i square matrices??like put matrices to the power of something
on excel???please help!!need it for my math portfolio!!
First off, assuming that by squaring a matrix you mean the result of the
matrix multiplication of a matrix by itself, this only works for square
matrices.
Assuming that the matrix values are in A1:C3,
=MMULT(A1:C3,A1:C3), array entered into a 3x3 range, will give you the
square;
=MMULT(MMULT(A1:C3,A1:C3),A1:C3), array entered into a 3x3 range, will
give you the cube; etc.
Alan Beban
|