how do i square matrices?
 

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

Answer: how do i square matrices?
 

Hello there! I'd be happy to help you with squaring matrices in Excel.

To square a matrix in Excel, you can use the MMULT function. The MMULT function multiplies two matrices together, so you can use it to multiply a matrix by itself (i.e. square it).

Here's how to do it:

1. First, enter your matrix into Excel. Let's say your matrix is in cells A1:B2.
2. Next, select a range of cells where you want the squared matrix to appear. For example, you could select cells D1:E2.
3. In the first cell of the range (D1), enter the following formula:
   Formula:

   ---

   =MMULT(A1:B2,A1:B2) 


   ---

4. Press Enter to calculate the formula. The resulting matrix will appear in the selected range (D1:E2).

That's it! You've now squared your matrix in Excel using the MMULT function.

Note that this method will only work for square matrices (i.e. matrices with the same number of rows and columns). If your matrix is not square, you won't be able to square it using this method.

I hope this helps with your math portfolio.

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!!

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

how do i square matrices?
 

Have a look at MMULT which lets you multiply two matrices.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"sparkskey" wrote in message
...
hello!!!how do i square matrices??like put matrices to the power of
something
on excel???please help!!need it for my math portfolio!!

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