摘要
目的:探索利用Excel软件建立四格表χ2检验自动校正处理程序。方法:利用Excel软件建立格式化的四格表χ2检验自动分析程序,在总样本数≥40和理论频数≥1时,通过Pearsonχ2检验和Yates校正公式,可自动给出χ2值和P值,在总样本<40或理论频数<1时,基于Fisher精确概率法,通过修改单元格引用,也可方便地得到χ2值和P值。结果与结论:利用Excel软件可实现四格表χ2检验,而且一旦格式固定,只要替换其中数值,就可立即得到χ2值。
OBJECTIVE： To develop autocorrection data processing program for fourfold table Chi- square test program based on Excel. METHODS： Formatted fourfold table Chi - square test auto- analyzer procedure was established based on Excel. If total samples were no less than 40 and the theoretical frequency was no less than 1, Chi - square value and probability value could be obtained by using Pearson＇s Chi- square formula and Yates＇ Chi- square correction formula, otherwise, the values will be calculated by revising form cell citation based on Fisher＇ s exact test. RESULTS ＆ CONCLUSIONS： Fourfold Chi- square test can be realized based on Excel, furthermore, once formatted worksheet is fixed, Chi Square value can be obtained as long as sample values in worksheet are replaced.
出处
《中国药房》
CAS
CSCD
北大核心
2008年第28期2235-2236,共2页
China Pharmacy
