Current location - Zhou Gong's Dream Interpretation Encyclopedia Official Website - Divination by drawing lots - Probability is set in EXCEL. How to quickly simulate these probabilities and randomly get the result of 10000 times?

Probability is set in EXCEL. How to quickly simulate these probabilities and randomly get the result of 10000 times?

As shown below: Enter the number of lucky draws in the second line of column ABC3,

a3 = IF(ROW()& lt； =A$2+2, RANDBETWEEN( 1, A$2), "") formula is pulled down to line 103.

B3 = IF(ROW()& lt； =B$2+2, RANDBETWEEN( 1, B$2), ""), and the formula is pulled down to line 1003.

C3 = IF(ROW()& lt； =C$2+2, RANDBETWEEN( 1, C$2), "") formula is pulled down to line 10003.

H3=COUNTIF(A$3:A$ 103, "& $2 * sum ($ g $3: $ g3))-countif (a $3: a $103,"< = "&

I3=COUNTIF(B$3:B$ 1003, "& $2 * sum ($ g $3: $ g3))-countif (b $3: b $1003,"< = "

JBOY3 =COUNTIF(C$3:C$ 10003, "& $2 * sum ($ g $3: $ G3))-countif (c $3: c $10003,"< =.

When finished, you can refresh the data by pressing F9 every time.

Related articles