|
|||||
|
|
| 用Excel对农业试验数据进行回归分析的方法 | |
| 引用本文： | 张明刚. 用Excel对农业试验数据进行回归分析的方法[J]. 贵州农业科学, 2009, 37(6) |
| 作者姓名： | 张明刚 |
| 作者单位： | 贵州省绥阳县农业局,贵州,绥阳,563300 |
| 摘 要： | 农业试验常常涉及回归分析,但其公式难记、运算繁琐.利用Excel 2003可轻松完成农业试验数据的一元回归分析,只需将数据录入Excel表格中,即可快捷地得到回归方程、回归坐标图,以及相关系数R.基本步骤:录入数据生成XY散点坐标图→添加趋势线得出回归线及回归方程、R2值→对分析结果进行显著性统计检验. |
| 关 键 词： | 农业试验 回归分析 |
Regression Analysis of Agricultural Testing Data by Excel 2003 |
|
| ZHANG Ming-gang. Regression Analysis of Agricultural Testing Data by Excel 2003[J]. Guizhou Agricultural Sciences, 2009, 37(6) | |
| Authors: | ZHANG Ming-gang |
| Affiliation: | Suiyang Agricultural Bureau;Suiyang;Guizhou 563300;China |
| Abstract: | Excel 2003 can be easily used in one monomial regression analysis of agricultural testing data and the regression equation,regression coordinate chart and correlation coefficient R can be acquired when the data are inputted in Excel sheet.The paper introduces the basic operation steps including inputting the data,adding the trend line and R2 value test according the graphic method. |
| Keywords: | Excel |
| 本文献已被 CNKI 万方数据 等数据库收录！ | |