Bibliography

  • Barnett, Raymond, Michael Ziegler, and Karl Byleen. College Mathematics for Business, Economics, Life Sciences, and Social Sciences, 13e, Pearson, 2015.

  • Haeussler, Ernest, Richard Paul, and Richard Wood, Introductory Mathematical Analysis for Business, Economics and the Life and Social Sciences, 13e, Pearson, 2011.

Appendix M5.1: ­Using Excel for Matrix Calculations

Three Excel functions are helpful with matrices: MMULT for matrix multiplication, MINVERSE for finding the inverse of the matrix, and MDETERM for finding the determinant of a matrix.

To multiply matrices in Excel, use MMULT as follows:

  1. Highlight all the cells that will contain the resulting matrix.

  2. Type = MMULT(matrix1, matrix2), where matrix1 and matrix2 are the ...

Get Quantitative Analysis for Management, 13/e now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial