Linear Algebra computations with real matrices. Linear Algebra

Linear Algebra

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Linear Algebra Computations - Linear Algebra With Real Matrices - Solution of Linear Systems of Equations

LINEAR ALGEBRA

LINEAR ALGEBRA performs computations with real matrices. Solution of linear systems of equations (even least squares solution of over-determined or inconsistent systems and solution by LU factors), matrix operations (add, subtract, multiply), finding the determinant, trace, inverse, adjoint, QR or LU factors, eigenvalues and eigenvectors, establish the definiteness of a symmetric matrix, perform scalar multiplication, transposition, shift, create matrices of zeroes or ones, identity, symmetric or general matrices.

Linear Algebra Details

Inverse (Compact) � Finds the inverse of a square matrix, if it exists. This version is somewhat faster and more memory efficient since it does not do the actual row exchanges for the pivoting, neither does it actually attach an identity matrix to the original one. The inverse computed is placed in the same array as the original matrix.

LU Factors - Finds the LU factors of a matrix [A], that is, [L] and [U] such that [A]=[L][U], with [L] being lower-triangular and [U] being upper-triangular. In reality, the factorization can't always be done without exchanging the rows of [A] in some manner. Because of this, a permutation matrix [P] is generally involved. This makes the actual factorization [A]=[P][L][U]. Also, since the program allows [A] to be rectangular, [U] in such case would not be square so instead of upper-triangular we should more accurately call it upper-trapezoidal. This program should be used before attempting to use the program which solves simultaneous linear equations using LU factors.

QR Factors (Gram-Schmidt orthogonalization) - Factors a matrix [A] with linearly independent columns into the product [A]=[Q][R], with [Q] having orthonormal columns and [R] being upper-triangular and invertible. Since [A] must have linearly independent columns, the number of columns can't exceed the number of rows.

Test Definiteness -Establishes the positive or negative definiteness, positive or negative semidefiniteness, or indefiniteness of a symmetric matrix.

Simultaneous Linear Equations -Solves systems of linear equations using the method of Gaussian Elimination.

Simultaneous Linear Equations by LU Factors -solves systems of linear equations using the LU factorization of the matrix of coefficients. This allows quicker solution of many systems that share the same matrix of coefficients but have different right-hand sides.

Simultaneous Linear Equations - Overdetermined or Inconsistent Systems -Finds the least-squares solution to a system of linear equations which may be inconsistent or overdetermined with more equations than unknowns.

Eigenvalues and Eigenvectors - Finds the real eigenvalues and corresponding eigenvectors of a matrix. If the matrix has a full set of eigenvectors (diagonalizable), then a full set will be found even if some eigenvalues are repeated. Eigenvalues are found using the Shifted QR method. The corresponding eigenvectors are found using the Shifted Inverse Power method. Matrices are first transformed into their upper-Hessenberg form.

Shift � Shifts the diagonal elements of a matrix (useful in the eigenvalue problem).

Create Matrix -Creates matrices of zeroes, ones, identity matrices, symmetric, random or general matrices.

Main Screen

Microsoft Excel - From Beginner to Expert in 6 Hours/ EXCEL DASHBOARD REPORTS

Excel Trader Package Technical Analysis in Excel With $139.00 of FREE software!

Microsoft � and Microsoft Excel � are registered trademarks of Microsoft Corporation. OzGrid is in no way associated with Microsoft