The QA section of the current issue of our IRW Newsletter has a practical piece of knowledge.

Question

In Excel, how do you multiply any two matrices M1 and M2 to get a third one M3?

Answer

I assume you know how to define an array in Excel (i.e., the first and last cell of a selected rectangular region defines an array).

Thus, let M1 be a matrix of r1 rows and c1 columns and M2 be a matrix of r2 rows and c2 columns. Let r1 = c2. Multiplying M1 times M2 results in a squared matrix M3 of r1 rows and c2 columns; i.e.

M1 * M2 = M3

To carry out this operation in EXCEL, do this:

1. Open a spreadsheet and enter M1 and M2 numerical data. Next, select an array region (r1 x c2) by dragging your mouse on the spreadsheet. This will be M3.

2. Type = MMULT(Array1, Array2) in the (fx) field. Next, Press F2.

3. Finally, press Ctrl + Shift + Enter and witness the magical black box of EXCEL.

An example is provided in Figure 1 of the newsletter.

From time to time, more complex math operations will be described in future issues of IRW.

Advertisements