### Matrics

A matrix is a rectangular array of numbers for which operations such as addition and multiplication are defined.

Real matrices are matrices that contain real numbers.

Complex matrices are matrices that contain complex number.__Excel > Functions > Matrix Category__

Rectangular array of numbers arranged in rows and columns

Matrices of the same size can be added or subtracted element by element

A square matrix has an inverse if and only if its determinant is non zero

sub matrix

row vector

column vector

#### Size

#### Identity

An identity matrix is a square matrix which contains all zeros except the main diagonal contains ones

#### Inverse

The inverse of a matrix is the matrix which when multiplied together gives the identity matrix.

To prove that these are in fact the correct inverses we need to multiply the two matrices together. This is shown below.

A matrix that has no inverse has a determinant of zero and is said to be singular.

The __MINVERSE__ function returns the inverse of the matrix as an array formula.

#### Addition

#### Multiplication

Matrix multiplication can only take place when the number of columns in the first matrix equals the number of rows in the second matrix.

Scalar multiplication

Matrix multiplication

This is usually entered as an array function and therefore must be entered with (Ctrl + Shift + Enter).

Matrix A multiplied by Matrix B is not the same as Matrix B multiplied by Matrix A (i.e. matrix multiplication is not commutative).

It is possible to use matrices to solve linear equations.

The __MMULT__ function returns the product of two matrices.

#### Determinant

This function only has an accuracy of 16 digits so a singular array may return a result that differs by 1E-16.

The __MDETERM__ function returns the matrix determinant as an array formula.

#### Transpose

This is usually entered as an array function and therefore must be entered with (Ctrl + Shift + Enter).

The first row of the input array becomes the first column of the output array.

The __TRANSPOSE__ function will transpose a matrix and return an array formula.

#### Linear Equations

Matrices can be used as a concise way to work with multiple linear equations.

#### Linear Transformations

#### Symmetric

#### Important

When using the MDETERM, MINVERSE and MMULT functions every cell in the array must contain a numeric value. If not the function will return #VALUE!

A matrix with "m" rows and "n" columns is said to be of order (m * n). When "m" and "n" are equal then the matrix is said to be square.

Two matrices are said to be identical if every element in one matrix equals the corresponding element in the other matrix.

Matrix multiplication is not commutative so (A * B) does not equal (B * A).

Matrix division is undefined.

An identity matrix is a square matrix that contains all zeros except the main diagonal contains the value 1.

© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited TopPrevNext