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.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
References
Yang, M., Lu, J.: In excel naming and calculating eigenvalues eigenvectors of matrix. Comput. Knowl. Technol. 14(3), 1295–1296 (2007)
Rong, S.: Excel VBA for then numerical calculation of the matrix eigenvalue. Jiangnan univ. J. (Nat. Sci. Ed.) 24(4), 418–422 (2009)
Golub, F.: Matrix Calculation. Science Press, Beijing (2001)
Lin, C.: Numerical methods (Part ii). Science Press, Beijing (2005)
ExcelHome. The actual combat skills essence of Excel VBA[M]. People’s Posts & Telecom Press, Beijing (2008)
Visual Basic 6.0 Chinese version, Introduction and Enhancement. Tsinghua University Press, Beijing (1999)
Zhong, Y.: The optimization for location for large commoditys regional distribution center. Adv. Soft Comput. 40, 969–979 (2007)
Zhong, Y.: The Design of A Controller in Fuzzy PETRI NET. Fuzzy Optim. Decis. Making 7(4), 399–408 (2008)
Zhong Y.: The structures and expressions of power group. Fuzzy Inf. Eng. 2(2):(2010)
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)
Author information
Authors and Affiliations
Corresponding author
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2014 Springer-Verlag Berlin Heidelberg
About this chapter
Cite this chapter
Yao, Wq. (2014). An Improved Optimization Algorithm for Solving Real Eigenvalue and Eigenvector of Matrixes. In: Cao, BY., Nasseri, H. (eds) Fuzzy Information & Engineering and Operations Research & Management. Advances in Intelligent Systems and Computing, vol 211. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-38667-1_9
Download citation
DOI: https://doi.org/10.1007/978-3-642-38667-1_9
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-38666-4
Online ISBN: 978-3-642-38667-1
eBook Packages: EngineeringEngineering (R0)