Applied statistical analysis for fourfold table data with the worksheet function of Excel

Q3 Medicine

中华地方病学杂志 Pub Date : 2011-11-20 DOI:10.3760/CMA.J.ISSN.1000-4955.2011.06.028

Liu-zhuo Zhang, Ping Qin, Ang Li, Juanjuan Zheng, Yuanjie Sun, C. Yuan, Yan Liu

{"title":"Applied statistical analysis for fourfold table data with the worksheet function of Excel","authors":"Liu-zhuo Zhang, Ping Qin, Ang Li, Juanjuan Zheng, Yuanjie Sun, C. Yuan, Yan Liu","doi":"10.3760/CMA.J.ISSN.1000-4955.2011.06.028","DOIUrl":null,"url":null,"abstract":"Objective To use Excel worksheet function to achieve statistical analysis of the fourfold table qualitative data,and to improve knowledge of the.majority of researchers on the statistical capabilities of Excel.Methods The result of actual research published in Chinese Journal of Endemiology was the data source,and statistical analysis results of fourfold table data from Excel and from SAS software were contrasted.Results The worksheet function of Excel could realize the analysis fourfold table data chi-square test,obtained an accurate P values,but not just P ＞ 0.05 or P ＜ 0.05.The results of chi-square test of Excel were the same as the results from SAS software,but Excel could not obtain probability value of fisher exact probability.Conclusion As a dependent statistical analysis software,Excel is an easy to learn,easy to use,efficient and a good helper.In the absence of professional statistical software,Excel can be used to achieve data statistical analysis. \n \nKey words: \nExcel worksheet function; SAS software; Fourfold table; Statistics","PeriodicalId":55880,"journal":{"name":"中华地方病学杂志","volume":"15 1","pages":"694-696"},"PeriodicalIF":0.0000,"publicationDate":"2011-11-20","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"0","resultStr":null,"platform":"Semanticscholar","paperid":null,"PeriodicalName":"中华地方病学杂志","FirstCategoryId":"3","ListUrlMain":"https://doi.org/10.3760/CMA.J.ISSN.1000-4955.2011.06.028","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"Q3","JCRName":"Medicine","Score":null,"Total":0}

引用次数: 0

Abstract

Objective To use Excel worksheet function to achieve statistical analysis of the fourfold table qualitative data,and to improve knowledge of the.majority of researchers on the statistical capabilities of Excel.Methods The result of actual research published in Chinese Journal of Endemiology was the data source,and statistical analysis results of fourfold table data from Excel and from SAS software were contrasted.Results The worksheet function of Excel could realize the analysis fourfold table data chi-square test,obtained an accurate P values,but not just P ＞ 0.05 or P ＜ 0.05.The results of chi-square test of Excel were the same as the results from SAS software,but Excel could not obtain probability value of fisher exact probability.Conclusion As a dependent statistical analysis software,Excel is an easy to learn,easy to use,efficient and a good helper.In the absence of professional statistical software,Excel can be used to achieve data statistical analysis. Key words: Excel worksheet function; SAS software; Fourfold table; Statistics

查看原文本刊更多论文

利用Excel的工作表功能对四重表数据进行统计分析

目的利用Excel工作表功能实现对四重表定性数据的统计分析，提高对四重表定性数据的认识。大多数研究人员对Excel的统计能力。方法以发表在《中国流行病学杂志》上的实际研究结果为数据来源，对Excel和SAS软件的四重表数据进行统计分析。结果Excel的工作表功能可以实现分析四重表数据的卡方检验，得到准确的P值，而不仅仅是P > 0.05或P < 0.05。Excel的卡方检验结果与SAS软件的结果一致，但Excel无法得到fisher精确概率的概率值。结论Excel是一种易学、易用、高效的统计分析软件，是一个很好的辅助工具。在没有专业统计软件的情况下，可以使用Excel来实现数据统计分析。关键词:Excel工作表功能;SAS软件;四倍表;统计数据

本文章由计算机程序翻译，如有差异，请以英文原文为准。

求助全文

约1分钟内获得全文求助全文

来源期刊

中华地方病学杂志我国对人类健康危害特别严重的地方性疾病：克山病、大骨节病、碘缺乏病、地方性氟中毒、地方性砷中毒、鼠疫、布鲁氏菌病、寄生虫、新冠肺炎等疾病，同时还报道多发性自然疫源性疾病。

CiteScore

1.60

自引率

0.00%

发文量

8714

期刊介绍： The Chinese Journal of Endemiology covers predominantly endemic diseases threatening health of the people in the areas affected by the diseases including Keshan disease, Kaschin-Beck Disease, iodine deficiency disorders, endemic fluorosis, endemic arsenism, plague, epidemic hemorrhagic fever, brucellosis, parasite diseases and the diseases related to local natural and socioeconomic conditions; and reports researches in the basic science, etiology, epidemiology, clinical practice, control as well as multidisciplinary studies on the diseases.