Excel在一元线性回归分析中的应用

Application of Excel in Unitary Linear Regression Analysis

回归分析有预测和因子分析的作用,但在实际运算中计算量大,随着软件的发展,许多运算过程可以用软件来替代;通过分析一元回归的建立过程,以成本预测为案例,应用Excel对案例进行回归方程的求解,并且对Excel的运行结果中的各参数进行具体解释,以至于能够理解各参数的实际意义,进而可以熟悉应用Excel进行回归分析,并能展开实际预测。

Regression analysis has the function of prediction and factor analysis,but it has a large amount of calculation in the actual operation.With the development of software,many operation processes can be replaced by software.This paper first analyzes the establishment process of univariate regression,and then takes the cost prediction as a case,applies Excel to solve the regression equation of the case,and specifically explains the parameters in the operation results of Excel,so that we can understand the practical significance of the parameters,and then we can be familiar with the application of Excel for regression analysis,and can carry out the actual prediction.