The Application of Excel Regression Analysis Tools in the Measurement of the Windings Temperature Rise
The electrical resistivity method survey conductor temperature principle is the conductor resistance value if the degrees Kelvin value has the direct ratio. The correlativity dependence may reflect between the variable exists relations, but is not the definite functional relation. Between the correlation variable, the use mathematical statistic related principle, may discover in statistics significance the functional relation. The method of regression line has used the differential coefficient extreme value principle; with it determined winding temperature ratio at power failure uses other mean more accurate somewhat. After the power failure the winding temperature and the time are the linear relations by no means. In the testing, the data acquisition must complete in a shorter time, by now the winding temperature and the time basically assumed the linear correlation relations, calculated the data was accurate. Through to coefficient of determination r, the F-test and the residual plot analysis, obtains the variable X with Y between whether has the remarkable linear correlation relations. Reads takes intercept and the slope (X Variable) from The result in the regression analysis uses in to establish the regression equation.
Temperaltrue rise Electrical resistivity method Regression analysis Correlation coefficient F-test Residual plot Excel worksheel
Fang Xiaoshi Wang Jianhua
National Copying Machine Quality Supervision Testing Center, Tianjin Reprography Technology Institute, Tianjin, China
国际会议
第六届影像科学与硬拷贝技术国际会议(ICISH08)(The 6th International Conference on Imaging Science and Hardcopy)
广东湛江
英文
210-212
2008-01-10（万方平台首次上网日期，不代表论文的发表时间）