{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

07 MatricesInExcel - 4 MDETERM – Matrix Determinant z...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Matrix Operations in Excel CEE 3804 Computer Applications for Civil and Environmental Engineers
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
CEE 3804 - Rojiani 2 Matrices in Excel z Excel has limited ability to work with matrices and solve linear equations. z Three built-in functions: MMULT, MDETERM, and MINVERSE. z Functions are live, and will recalculate automatically when input data changes. z User must select output range prior to typing function. z User must complete array formula with SHIFT- CTRL-ENTER
Image of page 2
CEE 3804 - Rojiani 3 MINVERSE – Matrix Inverse z Returns the inverse matrix for the matrix stored in an array. z Syntax: MINVERSE(array) z Array is a numeric array with an equal number of rows and columns.
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
CEE 3804 - Rojiani
Image of page 4