OBJECTIVE:To develop autocorrection data processing program for fourfold table Chi-square test program based on Excel.METHODS:Formatted fourfold table Chi-square test auto-analyzer procedure was established based on Excel.If total samples were no less than 40 and the theoretical frequency was no less than 1,Chi-square value and probability value could be obtained by using Pearson's Chi-square formula and Yates' Chi-square correction formula,otherwise,the values will be calculated by revising form cell citation based on Fisher's exact test.RESULTS & CONCLUSIONS:Fourfold Chi-square test can be realized based on Excel,furthermore,once formatted worksheet is fixed,Chi Square value can be obtained as long as sample values in worksheet are replaced.

Abstract OBJECTIVE To conduct visual analysis of the annual differentiated performance data of clinical pharmacists by using R language to find out the shortcomings and promote the progress of clinical pharmacists and department development. METHODS The weight scores of clinical pharmacists’ performance assessment in 2021 were collected, and R language was used to draw rectangular tree diagram, violin case diagram and Sankey diagram for data visualization analysis. RESULTS The basic work of clinical pharmacy department accounted for the largest weight, followed by clinical affairs, pharmaceutical quality control affairs and pioneering affairs in the middle of the weight, while teaching, scientific research weight was insufficient. There were also great differences in the weight of clinical pharmacists. Among the 8 clinical pharmacists, 3 focused on basic, 3 on all-round development, 1 on clinical, and the work weight of 1 needed to be comprehensively improved. CONCLUSION R language visualization can be used to analyze the weight composition of clinical pharmacy department, which is convenient to formulate the direction of department rectification and promote the improvement of clinical pharmacists team level.