Counting probability over a series of rolls

[TonyD1016]

I'm working on a personal project where I want to compare several dice roll methods by counting the results of a series of rolls.

-In the first instance I want to compare rolling 6 three-sided dice and counting all instances of two's and three's (a 2/3 chance of success per die) , versus flipping a coin 5 times and counting heads (effectively a two-sided die and only counting 2's).
-The second instance I want to compare flipping a coin six times and counting only heads, versus rolling 5 three-sided dice and counting only instances of three's (a 1/3 chance of success per die).

At the moment I have a sheet with nothing but a couple of columns containing a series of =RANDBETWEEN for each method and a =COUNTIF to count the "wins" for each method. This gives me individual results for a single roll, but I am looking to simulate the results over several hundred or thousand attempts.

What are some formulas that can accomplish this?

 

[BigBeachBananas]

How about using the binomial distribution?

Book1
	A	B	C	D	E	F
1	Rolling 3-sided dice				Flipping a coin
2	Number of Rolls	6			Number of Flip	5
3	Probability of success	0.667			Probability of success	0.500
4
5	Number of success	Probability			Number of success	Probability
6	0	0.001			0	0.031
7	1	0.016			1	0.156
8	2	0.082			2	0.313
9	3	0.219			3	0.313
10	4	0.329			4	0.156
11	5	0.263			5	0.031
12	6	0.088
Sheet1

Cell Formulas
Range	Formula
B3	B3	=2/3
F3	F3	=1/2
A6:A12	A6	=SEQUENCE($B$2+1,1,0,1)
E6:E11	E6	=SEQUENCE($F$2+1,1,0,1)
F6:F11	F6	=BINOM.DIST(E6,$F$2,$F$3,FALSE)
B6:B12	B6	=BINOM.DIST(A6,$B$2,$B$3,FALSE)
Dynamic array formulas.

 

[TonyD1016]

That will get me the expected results but I am looking for a way to essentially produce actual results.

Basically how can I generate a large list of random numbers and count the wins using the above requirements?

 

[JGordon11]

Book2
	A	B	C	D	E	F
1	Number of Dice	Dice Sides	Rolls	Success	Random trial % success
2	6	3	10000	2,3	66.773%
3	5	2	10000	2	49.680%
4	6	2	10000	2	50.227%
5	5	3	10000	3	33.440%
6
Sheet1

Cell Formulas
Range	Formula
E2	E2	=LET(ct, A2*C2,r,RANDARRAY(ct,1,1,B2,1), SUM((r=2)+(r=3))/(ct))
E3:E4	E3	=LET(ct, A3*C3,r,RANDARRAY(ct,1,1,B3,1), SUM((r=2)+0)/(ct))
E5	E5	=LET(ct, A5*C5,r,RANDARRAY(ct,1,1,B5,1), SUM((r=3)+0)/(ct))

 

[TonyD1016]

Oh I hadn't thought to use RANDARRAY. Thank you very much!