next up previous contents index
Next: EOMONTH Up: A. Function Reference Previous: EFFECT   Contents   Index


EIGEN

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


next up previous contents index
Next: EOMONTH Up: A. Function Reference Previous: EFFECT   Contents   Index
SpreadScript User's Guide, Version 1.2
Grey Trout Software
02 March 2003