摘要
在Windows98/Me/2000/XP系统中,利用Microsoft Excel软件的VBA编辑器编制了适合度检验函数,加上其自带的统计函数CHITEST、CHIINV建立卡方检验分析模板。计算时只需要在数据录入区输入原始数据,模板将自动进行处理分析,得出χ2值和P值,并显示判断结果。此模板大大简化了农业统计中卡方计算的繁琐,方便实用、快速准确、精确度高。
An chi-square test module was established by Microsoft Excel in Windows 98/Me/2000/XP. The module was compiled with the Excel＇s autonomous statistical functions of CHITEST, CHIINV and a compiled test function for goodness-of-fit with its self-supplied VBA editor. The chi-square and P value were automatically calculated by this module after the original data had been inputted. This module could greatly simplify chi-square calculations in agricultural statistics for its advantages of convenience, practical, rapid and high accuracy.
出处
《湖北农业科学》
北大核心
2010年第12期3192-3195,共4页
Hubei Agricultural Sciences
基金
现代农业产业技术体系建设专项资金资助项目(nycytx-03)
湖北省农业科技创新中心小麦育种专项(200762042042647001)
关键词
EXCEL软件
卡方检验
分析模板
农业统计
Excel software
chi-square test
analysis module
agricultural statistics
