07 MatricesInExcel

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

Info iconThis 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
Background image of page 1

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

View Full DocumentRight 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
Background 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.
Background image of page 3

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

View Full DocumentRight Arrow Icon
CEE 3804 - Rojiani
Background image of page 4
Background image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 4 MDETERM Matrix Determinant z Returns the matrix determinant of an array. z Syntax: MDETERM(array) z Array is a numeric array with an equal number of rows and columns. z The determinant for a noninvertable matrix is 0. CEE 3804 - Rojiani 5 MMULT Matrix Multiplication z Returns the matrix product of two arrays. The result is an array with the same number of rows as array1 and the same number of columns as array2. z Syntax: MMULT(array1,array2) z Array1, array2 are the arrays you want to multiply. z The number of columns in array1 must be the same as the number of rows in array2, and both arrays must contain only numbers....
View Full Document

This note was uploaded on 11/14/2008 for the course CEE 3804 taught by Professor Aatrani during the Fall '07 term at Virginia Tech.

Page1 / 5

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

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online