摘要
介绍一种利用EXCEL进行裂区试验统计分析的方法。根据方差分析原理,利用EXCEL编制了裂区试验统计分析计算程序。用户只需输入试验的原始数据,即可快速、准确地计算出各因素的平方和、均方和检验值F,其计算结果与专业统计软件DPS处理的结果基本一致。该程序使用方便,并可用于进行裂区试验统计分析。
The aim of this present study was to demonstrate a method for statistical analysis of split plot arrangement with Microsoft EXCEL.Based on the principle of analysis of variance,the procedure for statistical analysis of split plot arrangement was established with EXCEL.After the user input raw data of test,the procedure would calculate sum of squares,mean squares and F in variance analysis quickly and accurately.Moreover,the results used DPS and this procedure was matched.The program was flexible and could be applied to calculate statistical analysis of split plot arrangement.
出处
《中国农学通报》
CSCD
北大核心
2011年第30期159-163,共5页
Chinese Agricultural Science Bulletin
基金
中国热带农业科学院环境与植物保护研究所重大科技专项(No.2010hzsZDZX003)
关键词
EXCEL
裂区试验
统计分析
EXCEL
split plot arrangement
statistical analysis
