확률계산.xlsx

	E	F	H	I	J	K	L	M	N	O	Q	R	S	T
1
2					n	a	종류		Sigma (a = b, a = n) Comb(n-1,a-1) * (1-x) ^ (a-1) * x^(n-a+1) * 18 H (a-b) / 18 H (a)
3				1.025641026	100	3성 개수	4
4				0.08364737921		1	0	0%
5				0.2123356549		2	0	0%				배럭 수	평균 시행
6	x	개수	0.0008771929825	0.2667806946		3	0	0%				1	920	초
7	2.50%	18		0.2211771571		4	0.00003695524764	8.91%			기대값	리세 회수	걸리는 시간(시간)
8				0.1361090198		5	0.00009303418985	22.4%		SUM	50%	1671.520511	427.1663528
9				0.06630952244		6	0.0001123255603	27.1%		0.041%	90%	5552.670947	1419.015909
10				0.02663715859		7	0.00008773767651	21.2%			99%	11105.34189	2838.031817
11				0.009074196882		8	0.00005021294717	12.1%			99.99%	22210.68379	5676.063635
12				0.002675724722		9	0.00002255125852	5.4%
13				0.0006937064093		10	0.000008300760453	2.0%
14				0.0001600860945		11	0.000002580142182	0.6%
15				0.00003321133428		12	0.0000006921649812	0.2%
16				0.000006244866275		13	0.0000001629293701	0.0%
17				0.000001071604272		14	0.0000000340910814	0%
18				0.0000001687874861		15	0.000000006406977711	0%
19				0.00000002452467746		16	0.000000001090784775	0%
20				0.000000003301398889		17	0.0000000001694266292	0%
21				0.0000000004132972968		18	0	0%
22				0		19	0	0%
23				0		20	0	0%		1.38
24				0		21	0	0.00%
25				0		22	0	0.0%
26				0		23	0	0.0%
27				0		24	0	0.0%
28				0		25	0	0.0%
29				0		26	0	0.0%
30				0		27	0	0.0%
31				0		28	0	0.0%
32				0		29	0	0.0%
33				0		30	0	0.0%
34						31	0	0%
35						32	0	0%
36						33	0	0%
37						34	0	0%
38						35	0	0%
39						36	0	0%
40						37	0	0%
41						38	0	0.00%
42						39	0	0.0%
43						40	0	0.0%
44						41	0	0.0%
45						42	0	0.0%
46						43	0	0.0%
47						44	0	0.0%
48						45	0	0.0%
49						46	0	0.0%
50						47	0	0.0%
51						48	0	0%
52						49	0	0%
53						50	0	0%
54						51	0	0%
55						52	0	0%
56						53	0	0%
57						54	0	0%
58						55	0	0.00%
59						56	0	0.0%
60						57	0	0.0%
61						58	0	0.0%
62						59	0	0.0%
63						60	0	0.0%
64						61	0	0.0%
65						62	0	0.0%
66						63	0	0.0%
67						64	0	0.0%
68						65	0	0%
69						66	0	0%
70						67	0	0%
71						68	0	0%
72						69	0	0%
73						70	0	0%
74						71	0	0%
75						72	0	0.00%
76						73	0	0.0%
77						74	0	0.0%
78						75	0	0.0%
79						76	0	0.0%
80						77	0	0.0%
81						78	0	0.0%
82						79	0	0.0%
83						80	0	0.0%
84						81	0	0.0%
85						82	0	0%
86						83	0	0%
87						84	0	0%
88						85	0	0%
89						86	0	0%
90						87	0	0%
91						88	0	0%
92						89	0	0.00%
93						90	0	0.0%
94						91	0	0.0%
95						92	0	0.0%
96						93	0	0.0%
97						94	0	0.0%
98						95	0	0.0%
99						96	0	0.0%
100						97	0	0.0%