量表信度评估的快速实现方法

doi:10.3969/j.issn.1006-5253.2016.04.006

Abstract
Figure/Table
References
Related Citation (1)

Download: PDF (1801 KB) HTML (1 KB)
Export: BibTeX | EndNote (RIS)

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.

Key words： Kuder & Richardson reliability Cronbach′s alpha Hoyt Reliability Kendall coefficient of concordance Excel

Received: 13 January 2016

	Service

	E-mail this article
	Add to my bookshelf
	Add to citation manager
	E-mail Alert
	RSS
	Articles by authors
	Zhou Zhinian
	Peng Changhua
	Xiao Xiulin
	Wang Changzheng

Cite this article:

Zhou Zhinian,Peng Changhua,Xiao Xiulin, et al. Fast realization of the reliability evaluation of the scale[J]. journal1, 2016, 23(4): 258-262.

URL:

http://manu58.magtech.com.cn/Jwk_zgyytj/EN/10.3969/j.issn.1006-5253.2016.04.006 OR http://manu58.magtech.com.cn/Jwk_zgyytj/EN/Y2016/V23/I4/258

[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.