Syntax: EIGEN(M)
M = a matrix
EIGEN generates the eigenvalues of the matrix M, which must be square and symmetric.
Examples:
Matrix B9..C10 =
| B | C | |
| 9 | 0 | 1 |
|---|---|---|
| 10 | 1 | 2 |
EIGEN(B9..C10) =
| -0.414 |
| 2.4142 |
Matrix A1..B4 =
| A | B | |
| 1 | 0.99 | 0 |
|---|---|---|
| 2 | 3 | 6.2 |
| 3 | 4.1 | 1.1 |
| 4 | 3.3 | 6.3 |
EIGEN(A1..B4) = Error - EIGEN, matrix must be square
Matrix T5..V7 =
| T | U | V | |
| 5 | 1 | 2 | 3 |
|---|---|---|---|
| 6 | 2 | 3 | 9 |
| 7 | 3 | 9 | 2 |
EIGEN(T5..V7) =
| 0.02405 |
| -6.6074 |
| 12.5833 |
Excel function: N/A