Application of EXCEL to achieve the calculation of RSR and its evaluation.docVIP

 PAGE \* MERGEFORMAT 12 Application of EXCEL to achieve the calculation of RSR and its evaluation Author: Lin Pei-Hsien Wang Qingshan CHUNG Sin Hung Chen 【Abstract】 Objective: To explore the application of Excel to complete RSR method approach. Methods: Excel calculation functions, the preparation of the calculation of RSR program evaluation with an example calculation. Results: In Excel, you can complete the RSR in the rank of sub-types of indicators, RSR distribution and confidence intervals, regression equation, evaluation of sub-object file and harmonious test calculation, the calculation results are consistent with the SAS. Conclusion: Excel programs can be simple, fast and accurately complete the RSR calculations. Keywords: RSR; RSR; Excel RSR, also known as statistical information method [1], is a Professor Tian Fengdiao in 1988, proposed a comprehensive evaluation of non-parametric methods, in recent years, medical quality, medical services and receive a more comprehensive evaluation of a wide range of applications . In this study with examples, applications in OFFICE software, Excel spreadsheet RSR calculations. 1 Principles and Methods Rank sum ratio (RSR) is the evaluation index Rank, on average, reflecting a number of evaluation index of integrated information, the greater the value the more excellent the object of evaluations. RSR method’s basic steps [1]: 1.1 Raw Data Table The n-evaluation of objects and m-evaluation index arranged in n rows of the original data matrix of m columns. 1.2 Part-rank High-priority targets from small to large series of rank, low-priority targets descending series of ranks, the same person to take, on average, high priority targets Rank = (high-priority Rank + n / 2 0.5) / 2, slightly higher priority targets The Rank = ((high-priority Rank + n / 2 0.5) / 2 + n / 2 0.5) / 2 [2], the low priority targets Rank = (low priority Rank + n / 2 0.5) / 2, slightly lowe