Fast realization of the reliability evaluation of the scale
Zhou Zhinian1, Peng Changhua2, Xiao Xiulin2, Wang Changzheng2
1 Jingzhou Central Blood Bank, Jingzhou 434000, China; 2 Department of Clinical Laboratory, Jingzhou Hospital, Tongji Medical College, Huazhong University of Science and Technology
Abstract：Objective To explore the implementation method of calculating reliability coefficient for a variety measurement in Excel. Methods A cell in Excel can invoke the data in another cell. We deployed the original data and the intermediate computing data in the same named ′score table′ worksheet and deployed final conclusion of calculating reliability coefficient for a variety measurement in the same named ′reliability evaluation′ worksheet. The final conclusion of calculating reliability coefficient could be presented immediately along with the original data. Results When implementing the calculating reliability coefficient for a variety measurement, the reliability coefficient could be obtained only through logging in relevant original data instead of imputing any statistical formal and command if the Excel worksheet has been created. Conclusion It is possible to conduct calculating reliability coefficient for a variety measurement visually and quickly with the application of Excel.
周治年，彭长华，肖秀林，王长征. 量表信度评估的快速实现方法[J]. 中国医院统计, 2016, 23(4): 258-262.
Zhou Zhinian, Peng Changhua, Xiao Xiulin, Wang Changzheng. Fast realization of the reliability evaluation of the scale. journal1, 2016, 23(4): 258-262.
[1] 张超,陈平雁.急诊病人满意度量表的设计与评价[J].中国医院统计,2007,14(1):5-8. [2] 王颖,李艳,赫小宏,等.中文版临床学习环境评价量表的信度、效度检验[J].中国护理管理,2015,6:660-663. [3] 姜丽娜,李明,边旸.Gesell问卷用于评价小儿神经发育的信度及效度分析[J].临床和实验医学杂志,2015,14(13):1133-1135. [4] 谢帆,谢斌,金志兴,等.《精神障碍患者入院风险评估表》的编制[J].上海交通大学学报(医学版),2015,35(10):1534-1538. [5] 徐勇勇主编.中国医学统计百科全书:医学研究统计设计分册[M].北京:人民卫生出版社,2004:17 -20 . [6] 李洪兴,罗庆,张荣,等.肯德尔和谐系数W检验及程序实现[J].中国医院统计,2013,20(3):170-173. [7] 彭小娟,肖秀林,周治年.统计分析的Excel快速实现[M].武汉:武汉大学出版社,2012:262-276. [8] DAKO-GYEKE P, DORNOO B, AYISI ADDO S, et al. Towards elimination of mother-to-child transmission of HIV in Ghana: an analysis of national programme data[J]. International Journal for Equity in Health, 2016,15:5. [9] ALNAJJAR A, KHAN TA, MINA S, et al. The Student Authored Biomedical Publications at Alfaisal University, Saudi Arabia:a 6 year descriptive analysis[J]. SpringerPlus, 2015,4:754. [10]JAIN R, SHARMA R. A comparative study of effects of glycopyrrolate and ondansetron on nausea and vomiting in cesarean section under spinal anesthesia[J]. Anesth Essays Res, 2015,9(3):348-352. [11]周治年,彭小娟.Pearson、Spearman与Kendall′s Tau相关分析的Excel实现[J].临床和实验医学杂志,2012,11(6):461-463. [12]肖秀林,李诣然,彭小娟.Poisson分布资料统计推断的Excel快速实现方法[J].中国卫生检验杂志,2013,23(6):1605-1606. [13]周治年,彭长华,王昌富.Ridit分析组间两两比较的Excel快速实现[J].中国医院统计,2013,20(5):345-347. [14]周治年,彭小娟,肖秀林,等.二项分布资料统计推断的Excel快速实现[J].数理医药学杂志,2015,28(5):637-640. [15]周治年,彭长华,肖秀林,等.样本量和检验效能估计的Excel快速实现[J].数理医药学杂志,2015,28(6):791-795. [16]高永,王玖,石德文.加权TOPSIS法综合评价在Excel中的实现[J].中国卫生统计,2007,24(4):428-429.
