Matrix Multiplication, basic strategy
What does it mean to multiply one matrix by another? This is a really nice diagram that tells it all.
Practical Matrix Multiplication
What does all of this mean in real life? We are taught that the number of columns in the first matrix must equal the number of rows in the second matrix. Could this be more than a mental gymnastics right of passage for high school students?
Let us take a gal Joan that sells home made pies: apple, black berry, and coconut
Joan lives in western Washington State. Apples are pretty inexpensive, black berries grow as a weed, and fresh coconut is expensive. Joan uses spread sheets to keep track of how many pies she sells each day of the week, how much she sells them for, and how much it costs to produce them.
Open Office Calc, the free, open source cousin of Microsoft Excel.
Let us do the math for the first and put it in B8. It is very easy to write in the wrong formulas. The software makes it easy to visualize what you are doing.
What is cool about these spread sheets is that they can be saved and changed and the pie business changes. Say our pie shop owner contracts with some local high school students to harvest wild blackberries growing by the highway. The production cost drops to $3 per pie? The not so cool thing about these spread sheets is that entering each equation over and over is almost as PAINFUL as doing the entire beeping thing by hand, as per many high school math classes for the past few decades.
The EASY way to do Matrix Multiplication in Open Office
Open Office Calc has an easy way to calculate arrays.
- In the upper left hand corner, click on the fx function key
- Select the MMULT function
- Enter the values. A matrix in columns B to D and rows 2 to 3 would be written as B2:D3. You don’t even have to type this in. Simply use the left mouse key to highlight these cells on your spread sheet.
Here are the results in the finished spread sheet. Compare the results of B12:F13 with those in B8:F9.
Microsoft Office also performs the same calculations.