| 应用Excel进行方差分析和多重比较 |
| |
| 引用本文： | 武兆云.应用Excel进行方差分析和多重比较[J].安徽农业科学,2014(14):4172-4174,4182. |
| |
| 作者姓名： | 武兆云 |
| |
| 作者单位： | 河南农业大学烟草学院,河南郑州,450002 |
| |
| 摘 要： | 方差分析和多重比较是数据处理的常用数理统计方法之一.应用Excel进行方差分析易于操作,而多重比较比较困难.实际上,只需掌握若干个函数就可以多重比较.介绍在Microsoft Excel 2007中利用“数据分析”进行方差分析以及利用函数进行多重比较.
|
| 关 键 词： | 方差分析 多重比较 函数 Excel 2007 |
Analysis of Variance and Multiple Comparisons by Excel |
| |
| WU Zhao-yun.Analysis of Variance and Multiple Comparisons by Excel[J].Journal of Anhui Agricultural Sciences,2014(14):4172-4174,4182. |
| |
| Authors: | WU Zhao-yun |
| |
| Institution: | WU Zhao-yun(Tobacco College, Henan Agricultural University, Zhengzhou, Henan 450002) |
| |
| Abstract: | Analysis of variance and multiple comparisons is one of common used math-statistical methods to process data.Analysis of variance by Excel is easy to operate.However,multiple comparisons are tough to operate.Multiple comparisons have been done if we can grasp a number of functions.It was introduced that how to use ＂data analysis＂ to analysis of variance and use several functions to multiple comparisons by Microsoft Excel 2007. |
| |
| Keywords: | Variance analysis Multiple comparisons Functions Excel 2007 |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
