关键词: Excel, VBA, 四格表卡方检验, 医学检验专业, 临床教学

Abstract: Objective To realize the statistical analysis of data such as fourfold table chi-square test, evaluation and diagnostic test of four-fold table, and paired design of fourfold table chi-square test through Excel, so as to supplement the statistical function of chi-square test of Excel, and apply it to the teaching practice. Methods The statistical program is compiled through Excel VBA program interface to complete fourfold table chi-square and evaluation and diagnostic test, which compared with the case analysis of Health Statistics to vertify the accuracy of results. Results The input parameters include A (positive number in A rest), B (negative number in A test), C (positive number in B test) and D (negative number in B test). According to the above-mentioned conditions, the software automatically outputs the corresponding statistical description parameters: A+C, B+D, A+B, C, D, A+B+C+D, chi-square test, P values, and judgment. The assessment of diagnostic test and paired chi-square input parameters are: A (true positive), B (false positive), C (false negative) and D (true negative) should be numbers, otherwise there is a prompt dialog box. The software output corresponding statistical description parameters automatically according to these conditions: A+C, B+D, A+B, C+D, A+B+C+D, the diagnostic test's sensitivity, specificity, positive predictive value, negative predictive value and accuracy, matching chi-square test, P values and judgment. Conclusion Excel could replace manual process of fourfold tables data, automatically select the corresponding test statistics method, and provide P values and judgment.

Key words: Excel VBA, Fourfold table chi-square test, Medical laboratory specialty, Clinical teaching