Linker IT Software
Order Home
menubar-top-links menubar-top-rechts
SQL*XL: Database to Excel bridge ExcelLock: Lock and secure your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe
Home Products litLIB Help Vector and Matrix functions

Buy now

Download now

LITlib - Excel Power Functions Pack
 
Add-in for Excel that adds additional cell functions to Excel.

litLIB Help - EigenValues function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Vector and Matrix - EigenValues

Syntax:
= EigenValues(Matrix)

Description:
Calculates the eigenvalues of the matrix. The function returns a vector with eigenvalues.

The corresponding eigenvectors are calculated using the EigenVectors function. Eigenvalue i corresponds to the i-th column (the corresponding eigenvector) of the eigenvectors matrix.

The EigenValues is a matrix or array formula and you need to press CTRL+SHIFT+ENTER to apply it.

A restriction is that the input matrix needs to be a symmetrix matrix.

Example:
=EigenValues(A1:C3)
=EigenValues( mymatrix )

litLIB