ИССЛЕДОВАНИЕ НЕПОЛНОЙ ЛИНЕЙНОЙ РЕГРЕССИОННОЙ МОДЕЛИ ТЕРМИЧЕСКОГО СОПРОТИВЛЕНИЯ КОНТАКТНОЙ ПСЕВДОСРЕДЫ

Abstract

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.