Matrix Functions - Library
Synoposis - Available functions
- mtrx_Invert
- mtrx_Transpose
- mtrx_Determinant
- mtrx_Row
- mtrx_Column
- mtrx_LinEqSolve
- mtrx_Cholesky
- mtrx_QRDecomposition_R
- mtrx_SVDDecomposition
- mtrx_quickSort
- mtrx_EVDecomposition
Description
mtrx_Invert
Description : Performs matrix inversion.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input Matrix |
mtrx_Transpose
Description : Performs matrix transpose.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input Matrix |
mtrx_Determinant
Description : Calculate the determinant value of the input matrix.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input Matrix |
mtrx_Row
Description : Returns the nth row of the input matrix.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input Matrix |
| n | 2 | Index of the row |
mtrx_Column
Description : Returns the nth column of the input matrix.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input Matrix |
| n | 2 | Index of the column |
mtrx_LinEqSolve
Description : Matrix solution to samultaneous linear equation AX = Y. A = Input coefficient matrix. Y = RHS Vector.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| coeffMtrx | 1 2 3 6 |
Input coefficient matrix |
| rhsVector | 1 3 |
RHS vector |
mtrx_Cholesky
Description : Performs the Cholesky Decomposition of the matrix. Returns the resulting lower triangular matrix.
The input must be a positive definitive and symmetric square matrix .
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input matrix |
mtrx_QRDecomposition_R
Description : Performs the QR Decomposition of the matrix. A = QR. Returns the R matrix.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input matrix |
mtrx_SVDDecomposition
Description : Performs the SVD Decomposition of the m X n (where m >= n) matrix A. Input param = 1 will return m X m unary matrix, param = 2 will return m X n diagnal matrix and
param = 3 will return n X n conjugate matrix of a unary matrix.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input matrix |
| param | 1 2 or 3 | Input param |
mtrx_quickSort
Description : Performs quick sort on the input array. Input param = 1 will sort the array in the ascending order.
Param = 2 will sort in descending order.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 |
Input array |
| param | 1 or 2 | Input param |
mtrx_EVDecomposition
Description : Performs the Eigen Value Decomposition of the symmetric m X m matrix A. mtrx = V * D * V'.
Input param = 1 will return matrix V and param = 2 will return diagnal matrix D. Eigen values stored in matrix D.
Input parameters
| Input variable | Example | Description |
|---|---|---|
| mtrx | 1 2 3 6 |
Input matrix |
| param | 1 or 2 | Input param |
Requirements
- matrixfunctions.xll
