Accomplishing and Applying the Excel Program on Meta-Analysis for Medical Data of P, U, T, F and Χ~2-Values
Qingshan Chen
2009-01-01
Journal of Evidence-Based Medicine
Abstract:Objective To perform the program on meta-analysis of u-value, t-value, F-value, χ~2-value and Pvalue in Microsoft Excel. Method The Excel computational procedure was edited using IF statement and other relevant functions, such as SUM, NORMSINV, TDIST, FDIST and CHIDIST, etc. With real medical study data, valuate the results computed by the Excel program. Result The consolidated outcomes were generated and presented correctly with inputting quantitative-datas of different documents into the Excel calculating program, which agree with the results from the textbook. Conclusion Meta-analysis of u-value, t-value, F-value, χ~2-value and P-value can be accomplished in Excel conveniently, rapidly and accurately.