how can i do matrix by use Numbers

Hi bodoo,

In SG's example:

Matrix 1 is a table with 2 columns and 4 rows of cells.

Matrix 2 is a table with 3 columns and 2 rows of cells.

The cells in these two tables contain the arranged numbers making up the two matrices to be multiplied.

Note that the first has the same number of columns as the second has rows.

Result is a table with the same number of rows as Matrix 1 and the same number of columns as Matrix 2.

SG's formula is entered into cell A1 of Result, then filled down and right into the rest of the cells. The resulting array of numbers in another matrix, the result of the matrix multiplication of the first two.

Any of the tables can be resized for multiplication of matrices that are other sizes, provided the number of columns in Matrix 1 is the same as the number of rows in Matrix 2. The result table will also need to be resized to match the description above. Numbers should automatically fill the formula into larger versions of the Results table.

Here is a link to one of several online Matrix Multiplication Calculators that you can use to check these results (and the results of the Numbers document you create.

Regards,

Barry

Disclaimer: I receive no monetary or other benefit from the site link above.

Something like this?

In cell A1, filled right and down:

=SUMPRODUCT(Matrix 1::1:1,TRANSPOSE(Matrix 2::A))

SG