在EXCEL中设置了概率,如何可以快速模拟这些概率随机出结果10000次?

发布网友发布时间：2022-04-30 09:19

共2个回答

热心网友时间：2022-06-20 11:19

如下图：ABC3列第2行分别输入抽奖次数，

A3=IF(ROW()<=A$2+2,RANDBETWEEN(1,A$2),"")公式向下拉到103行

B3=IF(ROW()<=B$2+2,RANDBETWEEN(1,B$2),"")，公式向下拉到1003行

C3=IF(ROW()<=C$2+2,RANDBETWEEN(1,C$2),"")公式向下拉到10003行

H3=COUNTIF(A$3:A$103,"<="&A$2*SUM($G$3:$G3))-COUNTIF(A$3:A$103,"<="&A$2*SUM($G$2:$G2))公式下拉

I3=COUNTIF(B$3:B$1003,"<="&B$2*SUM($G$3:$G3))-COUNTIF(B$3:B$1003,"<="&B$2*SUM($G$2:$G2))公式下拉

J3=COUNTIF(C$3:C$10003,"<="&C$2*SUM($G$3:$G3))-COUNTIF(C$3:C$10003,"<="&C$2*SUM($G$2:$G2))公式下拉

做完后，每按一次F9键可以刷新数据

热心网友时间：2022-06-20 11:20

Excel指定文本按指定次数随机排序显示

Excel怎样列出合格率随机数