EIG matrix function

Description

EIG(A[,v]) returns the Eigenvalues of matrix A. Optionally, the eigenvectors are stored in the workspace variable v.

• EIG(A) returns a column vector containing the eigenvalues of square matrix A
• EIG(A,v) returns a diagonal matrix (D) of eigenvalues and stores into workspace variable v a matrix whose columns are the corresponding right eigenvectors, so that A*V = V*D.

Workspace variables

The value of a workspace variable is not stored in the spreadsheet, but in a separate memory space. The workspace variable name cannot be equal to a spreadsheet cell address (such as A1 or DC12), a spreadsheet function, or to a reserved word. In addition, it cannot contain a space or a character from the reserved character set: - + / * = < > # & @ $ | ^ : , ; . ( ) ' " [ ] { }.

Example

In the following example:

• in cell D3 a square matrix is created from the data in cell range A1 to C3.
• in cell D5 the formula EIG(D3,v) calculates and shows the Eigenvalues of the matrix created in cell D3, and stores the Eigenvectors in a workspace variable named "v".
• cell D6 contains v and shows the Eigenvectors that are stored in the workspace variable "v".

Download

 Eigenvalues.mc1

See also

• Matrices
• Matrix functions
• Mathematical functions