CAJ | 학술논문

在农业科学试验研究中,使用常规办法进行多元非线性回归分析难度大,不易操作。为此,对试验模型经过一定的数据转换,以三元二次非线性回归为例,阐述了用Excel做多元非线性回归的详细过程,并与SPSS软件做的结果进行比较。结果表明：使用Excel做多元非线性回归完全可行,且操作简单、易行,并就方程的统计意义进行了分析。
재농업과학시험연구중,사용상규판법진행다원비선성회귀분석난도대,불역조작。위차,대시험모형경과일정적수거전환,이삼원이차비선성회귀위례,천술료용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.