|
|||||
|
|
| 确切概率法Excel程序的编制及在医学中的应用 | |
| 引用本文： | 陈青山,王维,林佩贤,钟倩红,俞守义.确切概率法Excel程序的编制及在医学中的应用[J].南方医科大学学报,2009,29(4). |
| 作者姓名： | 陈青山 王维 林佩贤 钟倩红 俞守义 |
| 作者单位： | 1. 南方医科大学公共卫生与热带医学学院流行病教研室,广东广州,510515;暨南大学医学院流行病学教研室,广东,广州,510632 2. 深圳市宝安区妇幼保健院,广东,深圳518100 3. 暨南大学医学院流行病学教研室,广东,广州,510632 4. 南方医科大学公共卫生与热带医学学院流行病教研室,广东广州,510515 |
| 摘 要： | 目的 在Excel中编写和应用四格表资料Fisher确切概率法的计算程序.方法 应用ExeeI中if语句、sum、fact、dsum等计算函数,编写四格表资料确切概率法的Excel计算程序,结合医学实例比较和评价计算结果.结果 在Excel计算程序中输人四格表资料4个数值,即可得剑确切概率法计算的各组合表P值、双侧累加概率P双、单侧累加概率P(-)或P(+)以及直接卡方检验和校正卡方检验的X2值、P值,计算结果与SAS、SPSS结果一致.结论 在ExceI中可方便、快速、正确地完成四格表资料直接卡方检验、校正卡方检验和Fisher确切概率法的计算. |
| 关 键 词： | 四格表 Fisher确切概率法 医学统计 |
Application of Excel programs of Fisher exact probability test for medical data |
|
| CHEN Qing-shan,WANG Wei,LIN Pei-xian,ZHONG Qian-hong,YU Shou-yi.Application of Excel programs of Fisher exact probability test for medical data[J].Journal of Southern Medical University,2009,29(4). | |
| Authors: | CHEN Qing-shan WANG Wei LIN Pei-xian ZHONG Qian-hong YU Shou-yi |
| Institution: | CHEN Qing-shan1,2,WANG Wei3,LIN Pei-xian2,ZHONG Qian-hong2,YU Shou-yi1 1Epidemiology Division,Public Heath and Tropical Medicine College,Southern Medical University,Guangzhou 510515,China,2Epidemiology Division,Medical College of Jinan University,Guangzhou 510632,3Baoan Maternal and Child Health Hospital,Shenzhen 518100 |
| Abstract: | Objective To accomplish the computation of Fisher exact probability test for fourfold table data in Excel. Methods The computing program of exact probability method for medical data in fourfold table design was edited by employing the IF statement and the relevant functions, such as SUM, FACT, DSUM, etc in Excel. The computational results are compared and evaluated according to the case studies. Results The output of Fisher Exact Probability was generated and presented correctly following the input of four ... |
| Keywords: | Excel |
| 本文献已被 CNKI 万方数据 等数据库收录！ | |