Warning: html_entity_decode(): charset `off' not supported, assuming utf-8 in /var/www/zyzhang/wp-content/plugins/jetpack/_inc/lib/class.media-extractor.php on line 431

Warning: html_entity_decode(): charset `off' not supported, assuming utf-8 in /var/www/zyzhang/wp-content/plugins/jetpack/_inc/lib/class.media-extractor.php on line 431

Warning: html_entity_decode(): charset `off' not supported, assuming utf-8 in /var/www/zyzhang/wp-content/plugins/jetpack/_inc/lib/class.media-extractor.php on line 431

Warning: html_entity_decode(): charset `off' not supported, assuming utf-8 in /var/www/zyzhang/wp-content/plugins/jetpack/_inc/lib/class.media-extractor.php on line 431

使用Excel产生随机数

做抽样用得着的

1-10000的随机数

=RAND()*9999+1

若要产生整数,公式为

=INT(RAND()*9999+1)

当然,如果要产生1-100000的随机数,就把9999改成99999即可。

excel很博大精深啊。

2 Comments

Add a Comment

电子邮件地址不会被公开。

此站点使用Akismet来减少垃圾评论。了解我们如何处理您的评论数据