|
|
Use Excel VBA Function in Fourfold Table Statistics for Medical Laboratory Teaching
HUANG Hai-Ying, CHEN Bo, ZHOU Qiang, et al
JOURNAL OF CLINICAL TRANSFUSION AND LABORATORY MEDICINE
2021, 23 (6):
788-793.
DOI: 10.3969/j.issn.1671-2587.2021.06.025
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.
Reference |
Related Articles |
Metrics
|
|