Eigenvalues and Eigenvectors Using Excel with VBA

Author and university lecturer, Francis D. Hauser, PhD, defines and illustrates real-world applications of eigenvalues and eigenvectors.

From defining eigenvalues and eigenvectors to detailing their use in Excel with VBA, Hauser lays the foundation for his readers with a basic introduction of terms and then builds on that to a discussion of highly sophisticated software.

The work is a comprehensive illustration of how mathematicians, engineers, and programmers can harness the amazing computing power of Microsoft’s Excel software to analyze and design dynamic systems.

No matter your initial comfort level with eigenvalues, eigenvectors, mode shapes, and VBA, you’re sure to walk away from Hauser’s work with a deeper understanding at both the theoretical and practical levels.

Francis D. Hauser received his PhD in electrical engineering in 1972 from the University of Denver.

He is currently a dynamic systems analyst of the motion and control of spacecraft, watercraft, aircraft, and land craft.

He lectures for undergraduate, graduate, and continuing-education courses on topics ranging from Newtonian mechanics to linear algebra and automatic feedback control theory.

Hauser's other published works include Excel with VBA for Engineers and Mathematicians and The Golden Ratio: The Facts and the Myths.