employee from 01.01.1983 to 01.01.2023
Samara, Samara, Russian Federation
employee
Samara, Samara, Russian Federation
graduate student
Samara, Samara, Russian Federation
UDK 621 Общее машиностроение. Ядерная техника. Электротехника. Технология машиностроения в целом
BBK 344 Общее машиностроение. Машиноведение
The problems of analyzing the thermal pattern of the spindle assembly of the machine are considered. A technique for obtaining regression models in MS Excel environment is developed. A linear regression model of changing the contact thermal resistance is proposed without taking into account the interaction of factors in the thermal model of the joints of machine parts. Using the Correlation tool, a comparative assessment of the significance and elimination of some factors are performed by analyzing matching linear correlation coefficients. With the help of the Regression tool based on the least squares method (LSM), a numerical evaluation of the parameters of the proposed models and their quality check are performed; the homoscedasticity of the regression residues is proved; the statistical equivalence of the constructed models is analyzed.
correlation, regression, least squares method, homoscedasticity, linear regression model, correlation
1. Khokhlov VM, Khokhlova SV, Petrakov DI. Calculation of joints. Bryansk: VIMAKHO; 2007.
2. Mesnyankin SYu, Vikulov AG, Vikulov DG. Modern view on the problems of thermal contacting of solids. Physics-Uspekhi (Advances in Physical Sciences) 2009;179(9):945-970.
3. Zernin MV, Babin AP, Mishin AV, Burak VYu. Modeling of contact interaction using the provisions of the mechanics of the contact pseudo-medium. Bulletin of the Bryansk State Technical University. 2007;4(16):62-73.
4. Denisenko AF, Podkruglyak LYu. Construction of a regression model of thermal resistance of a contact pseudo medium. Izvestia of Samara Scientific Center of the Russian Academy of Sciences. 2021;23(3):47-54.
5. Denisenko AF, Podkruglyak LYu. Development of the heat model of the spindle support metal-cutting machine. Izvestia of Samara Scientific Center of the Russian Academy of Sciences. 2020;22(3):49-55.
6. Denisenko AF, Podkruglyak LYu. Heat model of a spindle support of a precesion metal cutting machine. IOP Conf. Series: Materials Science and Engineering 971. 2020: 022020. doihttps://doi.org/10.1088/1757-899X/971/2/022020
7. Kuritsky BYa. Search for optimal solutions using Excel 7.0. St. Petersburg: BHV-St. Petersburg; 1997.
8. Ketkina OS. MS Excel capabilities for regression analysis [Internet]. Ural Federal University; 2020. Available from: www.study.urfu.ru
9. Zaks L. Statistical evaluation. In: Adler YuP, Gorsky VG, editors. Moscow: Statistika; 1976.
10. Solving the multiple regression problem in Excel [Internet]. Available from: https://www.matburo.ru/ex_ec.php?p1=ecexcel
11. Hayman DN. Modern microeconomics: analysis and application. Moscow: Finance and Statistics; 1992.
