Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to center a square plot area in a square chart | Charts and Charting in Excel | |||
Regression Output -- R Square versus Adjusted R Square | Excel Discussion (Misc queries) | |||
Trying to find anything meaningful from Matrices | Excel Discussion (Misc queries) | |||
How to make the gridlines of a chart square | Charts and Charting in Excel | |||
How do I type 24 square metres using arithmetical notation | Excel Discussion (Misc queries) |