The Application of Excel Regression Analysis Tools in the Measurement of the Winding's 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.