| Excel软件在非线性回归分析中的应用探讨 |
| |
| 引用本文： | 田生昌. Excel软件在非线性回归分析中的应用探讨[J]. 宁夏农林科技, 2011, 52(11): 29-31 |
| |
| 作者姓名： | 田生昌 |
| |
| 作者单位： | 宁夏农林科学院银北盐改站,宁夏平罗,753400 |
| |
| 摘 要： | 在农业科学试验研究中,使用常规办法进行多元非线性回归分析难度大,不易操作。为此,对试验模型经过一定的数据转换,以三元二次非线性回归为例,阐述了用Excel做多元非线性回归的详细过程,并与SPSS软件做的结果进行比较。结果表明：使用Excel做多元非线性回归完全可行,且操作简单、易行,并就方程的统计意义进行了分析。
|
| 关 键 词： | Excel 数据转换 多元非线性 回归分析 |
Excel Software Used for Multi-nonlinear Regress Analysis and Discussion |
| |
| TIAN Shengchang. Excel Software Used for Multi-nonlinear Regress Analysis and Discussion[J]. Ningxia Journal of Agriculture and Forestry Science and Technology, 2011, 52(11): 29-31 |
| |
| Authors: | TIAN Shengchang |
| |
| Affiliation: | TIAN Shengchang(YinBei Saline Land Improvement Station of NingXia Academy of Agriculture and Forestry Science,Pingluo,Ningxia 753400) |
| |
| Abstract: | 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 oper... |
| |
| Keywords: | Excel software Data conversion Multi-nonlinear Regress analysis |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
