Abstract：Objective To develop a simple random sampling method suitable for researchers at all levels.Methods By using the inherent functions of rank (), rand (), vlookup () and if () of Excel and WPS softwares, the simple random sampling method is designed and the reusable sampling tool is customized.Results The simple random sampling method based on the function design of Excel or WPS can realize the simple random sampling of millions of research population in a few seconds. At the same time, it has the characteristics of simple design and use, short development time and reusability.Conclusion Compared with the sampling tool of Excel, which is only applicable to the data of digital population, the simple random sampling method based on the function design of Excel or WPS can not only realize the sampling of all character types, but also does not need to install add-on items, which is more suitable for health personnel at all levels.
颜玉炳，徐航，陈小平. 基于Excel或WPS软件的函数功能快速实现单纯随机抽样的方法设计[J]. 中国医院统计, 2022, 29(1): 78-80.
Yan Yubing, Xu Hang, Chen Xiaoping. Design of simple random sampling based on function of Excel or WPS. journal1, 2022, 29(1): 78-80.
