基于Excel或WPS软件的函数功能快速实现单纯随机抽样的方法设计

Design of simple random sampling based on function of Excel or WPS

目的开发适合各层级研究人员使用的单纯随机抽样方法。方法通过使用Excel或WPS软件固有的rank()、rand()、vlookup()和if()等函数,进行单纯随机抽样方法设计,定制可重复利用抽样工具。结果基于Excel或WPS软件的函数功能设计的单纯随机抽样方法,可在数秒内实现百万级研究总体的单纯随机抽样。同时该方法具有设计和使用简单,开发时间短,可以重复利用的特点。结论与Excel自带的抽样工具只适用于数字型总体的资料相比,基于Excel或WPS软件的函数功能设计的单纯随机抽样方法不仅可以实现所有字符类型总体的抽样,且无需安装加载项,更适用于各层级卫生人员使用。

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.