Microsoft Excel方差分析的使用

Variance Analysis by Microsoft Excel

在介绍了Excel数据分析功能的安装后 ,描述了如何用Excel进行农业试验设计的方差分析。Excel的单因素方差分析方法可以进行单因素完全随机试验设计的方差分析 ;Excel的无重复方差分析方法可以进行单因素随机区组和无重复的双因素方差分析 ;Excel的可重复双因素方差分析方法可以进行系统分组资料和完全随机的双因素试验设计的方差分析。

After introducing the installation of Excels Data Analysis Function, described three methods of analysis and how to use them for variance analysis of agricultural experiment data.Excels one factor variance analysis method can be used to one factor variance analysis of complete randomized experiment design data. Excels two factor variance analysis method without repetition can be used to variance analysis of one factor data with randomized blocks and two factor data without duplication. Excels two factor variance analysis with duplication can be used to variance analysis of systematic block data and complete randomized two factor experiment design data.