Skip to main content
Top

2014 | OriginalPaper | Chapter

An Improved Optimization Algorithm for Solving Real Eigenvalue and Eigenvector of Matrixes

Author : Wei-quan Yao

Published in: Fuzzy Information & Engineering and Operations Research & Management

Publisher: Springer Berlin Heidelberg

Activate our intelligent search to find suitable subject content or patents.

search-config
loading …

Abstract

In this paper, aiming to papers [1, 2]’s deficiency, we propose a method which changes to use the Excel’s single variable equations and regional operations with the Excel VBA programming. Finally, we get a method to solve the matrix eigenvalues and the eigenvectors by using Excel. The facts show that the method in this paper is better than the references’ methods.

Dont have a licence yet? Then find out more about our products and how to get one now:

Springer Professional "Wirtschaft+Technik"

Online-Abonnement

Mit Springer Professional "Wirtschaft+Technik" erhalten Sie Zugriff auf:

  • über 102.000 Bücher
  • über 537 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Maschinenbau + Werkstoffe
  • Versicherung + Risiko

Jetzt Wissensvorsprung sichern!

Springer Professional "Technik"

Online-Abonnement

Mit Springer Professional "Technik" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 390 Zeitschriften

aus folgenden Fachgebieten:

  • Automobil + Motoren
  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Elektrotechnik + Elektronik
  • Energie + Nachhaltigkeit
  • Maschinenbau + Werkstoffe




 

Jetzt Wissensvorsprung sichern!

Springer Professional "Wirtschaft"

Online-Abonnement

Mit Springer Professional "Wirtschaft" erhalten Sie Zugriff auf:

  • über 67.000 Bücher
  • über 340 Zeitschriften

aus folgenden Fachgebieten:

  • Bauwesen + Immobilien
  • Business IT + Informatik
  • Finance + Banking
  • Management + Führung
  • Marketing + Vertrieb
  • Versicherung + Risiko




Jetzt Wissensvorsprung sichern!

Literature
1.
go back to reference Yang, M., Lu, J.: In excel naming and calculating eigenvalues eigenvectors of matrix. Comput. Knowl. Technol. 14(3), 1295–1296 (2007) Yang, M., Lu, J.: In excel naming and calculating eigenvalues eigenvectors of matrix. Comput. Knowl. Technol. 14(3), 1295–1296 (2007)
2.
go back to reference Rong, S.: Excel VBA for then numerical calculation of the matrix eigenvalue. Jiangnan univ. J. (Nat. Sci. Ed.) 24(4), 418–422 (2009)MathSciNet Rong, S.: Excel VBA for then numerical calculation of the matrix eigenvalue. Jiangnan univ. J. (Nat. Sci. Ed.) 24(4), 418–422 (2009)MathSciNet
3.
go back to reference Golub, F.: Matrix Calculation. Science Press, Beijing (2001) Golub, F.: Matrix Calculation. Science Press, Beijing (2001)
4.
go back to reference Lin, C.: Numerical methods (Part ii). Science Press, Beijing (2005) Lin, C.: Numerical methods (Part ii). Science Press, Beijing (2005)
5.
go back to reference ExcelHome. The actual combat skills essence of Excel VBA[M]. People’s Posts & Telecom Press, Beijing (2008) ExcelHome. The actual combat skills essence of Excel VBA[M]. People’s Posts & Telecom Press, Beijing (2008)
6.
go back to reference Visual Basic 6.0 Chinese version, Introduction and Enhancement. Tsinghua University Press, Beijing (1999) Visual Basic 6.0 Chinese version, Introduction and Enhancement. Tsinghua University Press, Beijing (1999)
7.
go back to reference Zhong, Y.: The optimization for location for large commoditys regional distribution center. Adv. Soft Comput. 40, 969–979 (2007)CrossRef Zhong, Y.: The optimization for location for large commoditys regional distribution center. Adv. Soft Comput. 40, 969–979 (2007)CrossRef
8.
go back to reference Zhong, Y.: The Design of A Controller in Fuzzy PETRI NET. Fuzzy Optim. Decis. Making 7(4), 399–408 (2008)CrossRefMATH Zhong, Y.: The Design of A Controller in Fuzzy PETRI NET. Fuzzy Optim. Decis. Making 7(4), 399–408 (2008)CrossRefMATH
9.
go back to reference Zhong Y.: The structures and expressions of power group. Fuzzy Inf. Eng. 2(2):(2010) Zhong Y.: The structures and expressions of power group. Fuzzy Inf. Eng. 2(2):(2010)
10.
go back to reference Zhong, Y., Deng, H., Chen, H.: A fuzzy logic based mobile intelligent system for eeEvaluating and selecting hotels in tourism, pp. 733–737. IEEEof International Conference on Web Information Systems and Mining (2009) Zhong, Y., Deng, H., Chen, H.: A fuzzy logic based mobile intelligent system for eeEvaluating and selecting hotels in tourism, pp. 733–737. IEEEof International Conference on Web Information Systems and Mining (2009)
Metadata
Title
An Improved Optimization Algorithm for Solving Real Eigenvalue and Eigenvector of Matrixes
Author
Wei-quan Yao
Copyright Year
2014
Publisher
Springer Berlin Heidelberg
DOI
https://doi.org/10.1007/978-3-642-38667-1_9

Premium Partner