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 - EigenVectors function
litLIB Help
Product pages :
litLIB
Quick links:
help index
forums

Vector and Matrix - EigenVectors

Syntax:
= EigenVectors(Matrix)

Description:
Calculates the eigenvectors of the given matrix. The eigenvectors are returned in columns and correspond to the eigenvalues that can be calculated using the EigenValues function. In the resulting matrix column i is the eigenvector for the i-th eigenvalue.

The EigenVectors 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:
=EigenVectors(A1:C3)
=EigenVectors( mymatrix )

litLIB