Excel软件在非线性回归分析中的应用探讨

Excel Software Used for Multi-nonlinear Regress Analysis and Discussion

在农业科学试验研究中,使用常规办法进行多元非线性回归分析难度大,不易操作。为此,对试验模型经过一定的数据转换,以三元二次非线性回归为例,阐述了用Excel做多元非线性回归的详细过程,并与SPSS软件做的结果进行比较。结果表明:使用Excel做多元非线性回归完全可行,且操作简单、易行,并就方程的统计意义进行了分析。

Multi-nonlinear regression analysis by usual method used in agricultural experimental research was difficult to operate.Hence after the data transformation of test model,with the multi-nonlinear regression analysis by ＂date analysis＂ tool of Microsoft Excel as example,a 2 times nonlinear regress analysis process was described.The results showed that the data output result processed by Excel was same as that of SPSS software.Excel software used for multi-nonlinear regress analysis was feasible and easy to operate.The statistical significance of the 2 times nonlinear regress equation was also analyzed.