...中按男女比例2:1进行分层抽样,抽取30个样本(Excel操作流程)?_百度知...答:在A列输入学生姓名,B列为性别,C2=rand(),d2=rank(C2,C$2:c$51,0),两个公式下拉自动填充。从f2开始依次向下输入1,2,3,……,20,g列输入男,h2=index(a$2:a$51,math(small(if(b$2:b$51="男",d$2:d$51,1000),row(a1)),d$2:d$51,0)),同时按Ctrl+shit+回车形成...
如何从excel表里面用函数随机抽取男女各两名?答:I$3:I$4,I3)>1),INDEX($C:$C,INDEX(SMALL(IF($B$3:$B$19=I$2,ROW($3:$19),4^10),ROW(INDIRECT("1:"&COUNTIF($B$3:$B$19,I$2))),RANDBETWEEN(1,COUNTIF($B$3:$B$19,I$2))),I3))同时按Ctrl+Shift+Enter三键输入数组公式,右拉J2,再一起下拉到第I3:J3 ...