METHODS OF CALCULATION OF OWN VALUES AND OWN VECTORS OF THE MATRIX IN EXCEL SWITCHES

Authors

  • Yu. A. Tolbatov НАУ

Abstract

The paper considers three methods for calculating the eigenvalues and eigenvectors of the matrix in the shell of Excel spreadsheets (ET). The method of finding the eigenvalues of the matrix using the built-in mathematical function for calculating the determinant MOPRED and the program "Solution Search", as well as the numerical method of excluding the found eigenvalues from the characteristic equation.

Author Biography

Yu. A. Tolbatov , НАУ

канд. техн. наук

References

Толбатов Ю. А. О колебаниях пологих цилиндрических оболочек, подкрепленных эксцентричными ребрами жесткости. Строительство, конструкции, основания и фундаменты. Под ред. И. А. Лукашенко. - М.: Высшая школа, 1974. - С.81-89.

Бабаков И. М. Теория колебаний. - М.: Дрофа, 2004. - 592 с.

Толбатов Ю. А, Толбатов Є. Ю. Елементи лінійної алгебри та аналітичної геометрії: Навч. посібник. - К.: Четверта хвиля, 2002. - 192 с.

Мазаракі А. А., Толбатов Ю. А. Математичне програмування в Excel. Навч. посібник. - К.: Четверта хвиля, 1998. - 208 с.

Downloads

Published

2005-09-30

How to Cite

Tolbatov , Y. A. (2005). METHODS OF CALCULATION OF OWN VALUES AND OWN VECTORS OF THE MATRIX IN EXCEL SWITCHES. Problems of Informatization and Management, 3(14), 142–149. Retrieved from https://jrnl.kai.edu.ua/index.php/PIU/article/view/16326

Issue

Vol. 3 No. 14 (2005)

Section

Статті

License

The scientific journal adheres to the principles of Open Access and provides free, immediate, and permanent access to all published materials without financial, technical, or legal barriers for readers.

All articles are published in Open Access under the Creative Commons Attribution 4.0 International (CC BY 4.0) license.

Copyright

Authors who publish their works in the journal:

  • retain the copyright to their publications;

  • grant the journal the right of first publication of the article;

  • agree to the distribution of their materials under the CC BY 4.0 license;

  • have the right to reuse, archive, and distribute their works (including in institutional and subject repositories), provided that proper reference is made to the original publication in the journal.