An Auxiliary Judgment Method with Multiple Regression Analysis

Abstract

This paper refers to as various results of regression calculators on the website among some of the results are either too complicated or too concise, so that the author summarized those results data from SPSS system of EXCEL software and regression calculators, during found it was ambiguous to interpretation and judgment. therefore, boosting an ideal to develop a simple and effective judgment method out to resolve those questions.  This method is verified with a group of actual data; however, all steps have executed through the SPSS system of EXCEL application software. Which development steps are as follows: firstly, collecting variable (dependent variable and independent variable) data, secondly, completed the results of multiple regression analysis through the SPSS system, finally the results data values are converted into text interpretation and judgment model. The analysis results of regression converted into text model which is a highlight point in paper. Taking an example to verify from the data of combustible gases in the insulating oil of power transformers, such as hydrogen (H2), methane (CH4), ethane (C2H2), ethylene (C2H4), acetylene (C2H6) and carbon monoxide (CO), as variables through the method to test, then the results data were compared with the result were calculated through the regression analysis calculator on website, and all results were consistent, so that verified the method is feasibility, and more simply and clearly for judgment.  Meanwhile, the author hopes it can set a standard for regression analysis of judgment and interpretation. This paper provides a novel approach to regression analysis by introducing a method that translates complex statistical results into text-based judgments. This simplification is crucial for enhancing the accessibility of regression analysis, particularly for professionals in fields where statistical expertise may not be prevalent. Based on the principle of experience sharing, the research results are written down for reference by scholars and interested colleagues of in electricity field.