应用Excel进行方差分析和多重比较
comparisons作者：***
来源：《安徽农业科学》2014年第14期
        摘要方差分析和多重比较是数据处理的常用数理统计方法之一。应用Excel进行方差分析易于操作，而多重比较比较困难。实际上，只需掌握若干个函数就可以多重比较。介绍在Microsoft Excel 2007 中利用“数据分析”进行方差分析以及利用函数进行多重比较。
        关键词方差分析；多重比较；函数；Excel 2007
        中图分类号S11文献标识码A文章编号0517-6611（2014）14-04172-03
        Analysis of Variance and Multiple Comparisons by Excel
        WU Zhaoyun（Tobacco College， Henan Agricultural University， Zhengzhou， Henan 450002）
        Abstract Analysis of variance and multiple comparisons is one of common used mathstatistical 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.