how do i square matrices?

S

sparkskey

hello!!!how do i square matrices??like put matrices to the power of something
on excel???please help!!need it for my math portfolio!!
 
R

Rob Hick

sparkskey said:
hello!!!how do i square matrices??like put matrices to the power of something
on excel???please help!!need it for my math portfolio!!
Click to expand...

As far as I know there is no way of doing this in Excel. Squaring
matrices is a failry complicated mathematical process so you'd be
better using a maths package. If you have got one and are after some
freeware - check out 'Octave' (google it). It's an opensource version
of matlab and it's a breeze to do maths in.

Try something like

A = [1,2,3;1,2,3;1,2,3]
B = A*A
B

Hope that helps,
Rob
 
A

Alan Beban

sparkskey said:
hello!!!how do i square matrices??like put matrices to the power of something
on excel???please help!!need it for my math portfolio!!
Click to expand...

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
 
Top