利用Excel软件建立卡方检验分析模板在农业统计中的应用  

Application of Excel in Establishment of Chi-square Test Analysis Module in Agricultural Statistics

作　　者：谭永强[1] 余华强[1] 陈桥生[1] 刘莹[1] 

机构地区：[1]襄樊市农业科学院,湖北襄樊441057

出　　处：《湖北农业科学》2010年第12期3192-3195,共4页Hubei Agricultural Sciences

基　　金：现代农业产业技术体系建设专项资金资助项目(nycytx-03);湖北省农业科技创新中心小麦育种专项(200762042042647001)

摘　　要：在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.

关 键 词：EXCEL软件 卡方检验 分析模板 农业统计 

分 类 号：S114[农业科学—农业基础科学] S126