Excel软件统计函数在医药资料设计X^2检验中的应用

Application of Excel in X^2 Test of Medical Data Design

目的:探索利用Excel软件统计函数进行X2检验。方法:建立格式化的电子表格,利用Excel软件统计函数CHITEST、CHIINV、CHIDIST进行X2检验运算。结果与结论:利用Excel软件统计函数可实现格式化X2检验,且一旦格式固定,只要替换其中数值,就可立即得到X2值。

OBJECTIVE：To conduct X^2 test using excel statistical function.METHODS： Formatted worksheet was set up and the X^2 test was performed using excel statistical functions that consists of CHITEST,CHIINV AND CHIDIST.RESULTS ＆ CONCLUSION： X^2 test was able to be performed using Excel statistical function.X^2 valne was available once the format is fixed and the numerical values in worksheet are replaced.