Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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!!
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up 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.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 16
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,393
Default 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!!



  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 200
Default 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to center a square plot area in a square chart xppuser Charts and Charting in Excel 2 March 11th 06 09:13 AM
Regression Output -- R Square versus Adjusted R Square Bonnie Excel Discussion (Misc queries) 1 October 25th 05 12:55 AM
Trying to find anything meaningful from Matrices langba Excel Discussion (Misc queries) 1 September 30th 05 07:45 PM
How to make the gridlines of a chart square Ali Baba Charts and Charting in Excel 3 September 13th 05 12:58 PM
How do I type 24 square metres using arithmetical notation Howard Excel Discussion (Misc queries) 5 August 2nd 05 02:14 AM


All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"