4. Matrix Operations in Excel. Matrix （4所示。）.pdf

CHEN 3600 – Computer-Aided Chemical Engineering Chemical Engineering Department Notes 4 EWE: “Engineering With Excel” Larsen Page 1 4. Matrix Operations in Excel. Matrix Manipulations: Vectors, Matrices, and Arrays. How Excel Handles Matrix Math. Basic Matrix Operations. Solving Systems of Linear Equations. Matrix Manipulations: Vectors, Matrices, and Arrays. In this section we consider the topic of Vectors, Matrices and Arrays and their application in solving Linear Equations and other linear algebra problems. Simultaneous linear equations occur frequently in engineering in such areas as heat conduction, molecular diffusion, fluid mechanics and in data regression. Excel’s “Solver” feature will be used in a later chapter to solve more complicated linear and nonlinear systems of equations. Generally the term matrix (from mathematics) and array (from Excel) can be used interchangeably to refer to data organized in row and column fashion. Matrices consisting of a single row or a single column are called vectors. Even though the functions are “named” with matrix there is no help in Excel under “matrix” only “array”. Typical Linear Equation Set and Corresponding Matrices a x + a x +a x = b 11 1 12 2 13 3 1 a x + a x +a x = b 21 1 22 2 23 3 2 a x + a x +a x = b 31 1 32 2 33 3 3 a11 a12 a13 x 1 b1 Where [A] = a21 a22 a23 [X] = x 2 [B] = b2 a31 a32 a33 x 3 b3 Is represented in math as [A][X] = [B] and has the solution [X] = [A]-1 [B] How Excel Handles Matrix Math. Matrix operations are handled in two different fashions in Excel. Addition of matrices and scalar multiplication are handled by conventional cell arithmetic (copying cell formulas) whereas adv