YTA - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Your # of tickets:	3		MARK6	<- My referral code which gives you a bonus 500 tickets in your first drawing
2
3				Odds to win prize at least once in a					Expected ticket value
4	Combo	Prize	True Value	Day	Month	Year			in cents not $	APR	Apprx APY
5	Match 5 + Yotta Ball	$1,000,000	$999,294	0.000000%	0.0000%	0.0000%		base prizes	0.121	1.76%	1.78%
6	Match 5	$20,000	$18,678	0.000%	0.000%	0.002%		with 1K and 2K	0.140	2.05%	2.07%
7	Match 4 + Yotta Ball	$2,000	$1,462	0.00%	0.00%	0.01%		with all prizes	0.180	2.63%	2.67%
8	Match 4	$1,000	$15.37	0.00%	0.06%	0.71%
9	Match 3 + Yotta Ball	$20	$20	0.00%	0.06%	0.67%			Odds of having at least one person
10	Match 3	$0.20	$0.20	0.18%	5.30%	48.45%				winning the given prize this
11	Match 2 + Yotta Ball	$0.75	$0.75	0.06%	1.69%	18.72%			Day	Month	Year
12	Match 2	$0.02	$0.02	5.46%	81.46%	100.00%		$1,000,000	0.14%	4.15%	40.28%
13	Match 1 + Yotta Ball	$0.10	$0.10	0.64%	17.64%	90.56%		$20,000	12.93%	98.43%	100.00%
14	Match 0 + Yotta Ball	$0.03	$0.03	2.31%	50.36%	99.98%		$2,000	48.51%	100.00%	100.00%
15
16			Your expected winnings per
17		Day	Month	Year
18	Average(non-pooled)	$0.00	$0.11	$1.32
19	Average(all prizes)	$0.01	$0.16	$1.97
20	1st percentile	$0.00	$0.00	$0.53
21	2nd percentile	$0.00	$0.00	$0.57
22	5th percentile	$0.00	$0.00	$0.65
23	10th percentile	$0.00	$0.02	$0.72
24	25th percentile	$0.00	$0.04	$0.88
25	40th percentile	$0.00	$0.05	$1.01
26	Median	$0.00	$0.06	$1.08
27	60th percentile	$0.00	$0.08	$1.18
28	75th percentile	$0.01	$0.12	$1.41
29	90th percentile	$0.01	$0.20	$1.87
30	95th percentile	$0.01	$0.26	$2.16
31	98th percentile	$0.03	$0.68	$2.79
32	99th percentile	$0.04	$0.76	$18.40
33
34			Avg. num. of____ before winning
35	Combo	Prize	Days	Months	Years
36	Match 5 + Yotta Ball	$1,000,000	2,360,263,752	78,675,458	6,466,476
37	Match 5	$20,000	24,084,324	802,811	65,984
38	Match 4 + Yotta Ball	$2,000	5,021,838	167,395	13,758
39	Match 4	$1,000	51,243	1,708	140
40	Match 3 + Yotta Ball	$20	53,998	1,800	148
41	Match 3	$0.20	551	18	2
42	Match 2 + Yotta Ball	$0.75	1,761	59	5
43	Match 2	$0.02	18	1	1
44	Match 1 + Yotta Ball	$0.10	155	5	1
45	Match 0 + Yotta Ball	$0.03	43	1	1
46
47
48
49
50	Calculations area:
51	estimated tickets	10,000,000
52
53		combos	odds	nominal prize	EV/ticket	actual $
54	Match 5 + 1	1	0.0000000001412271544	1000000	0.0001411274625	999294.1025		7,080,791,256
55	Match 5 + 0	98	0.00000001384026113	20000	0.0002585039059	18677.67547		72,252,972
56	Match 4 + 1	470	0.00000006637676257	2000	0.00009701846305	1461.632947		15,065,513
57	Match 4 + 0	46,060	0.000006504922732	1000	0.0001	15.37297277		153,730
58	Match 3 + 1	43,710	0.000006173038919	20	0.0001234607784			161,995
59	Match 3 + 0	4,283,580	0.0006049578141	0.2	0.0001209915628			1,653
60	Match 2 + 1	1,340,440	0.0001893065268	0.75	0.0001419798951			5,282
61	Match 2 + 0	131,363,120	0.01855203963	0.02	0.0003710407926			54
62	Match 1 + 1	15,247,505	0.002153361743	0.1	0.0002153361743			464
63	Match 0 + 1	54,891,018	0.007752102274	0.03	0.0002325630682			129
64	Match 1 + 0	1,494,255,490	0.2110294508	0	0			5
65	Match 0 + 0	5,379,319,764	0.7597060229	0	0			1
66
67		7080791256	1		0.001802022103
68
69
70
71
72
73
74			10	20	50	100	200	400	700	1000	2000	4000	7000	10000	20000	40000	70000	100000	120000	150000	200000
75	1st percentile	0	0	0	0	0	0.0001	0.000275	0.0004	0.00048	0.000605	0.0007125	0.0007814285714	0.000828	0.00090125	0.00095475	0.0009863571429	0.001012	0.001019083333	0.001031333333	0.00104895
76	2nd percentile	0	0	0	0	0	0.0002	0.000325	0.0004428571429	0.00052	0.00065	0.0007425	0.0008092857143	0.0008535	0.0009205	0.00097	0.001000357143	0.00102555	0.001032416667	0.001043933333	0.001061125
77	5th percentile	0	0	0	0	0	0.00025	0.000425	0.0005142857143	0.00059	0.00071	0.0007925	0.0008542857143	0.000893	0.00095075	0.0009965	0.001025214286	0.0010437	0.001053083333	0.001064933333	0.001092075
78	10th percentile	0	0	0	0	0.0002	0.00035	0.0005	0.0006	0.00066	0.000765	0.0008425	0.0008957142857	0.00093	0.00098275	0.00102125	0.001045928571	0.001066	0.00107725	0.001093866667	0.00113475
79	25th percentile	0	0	0	0.0004	0.0004	0.00055	0.000675	0.0007571428571	0.0008	0.000875	0.00094	0.0009742857143	0.001004	0.001037	0.001067875	0.001093571429	0.0011326	0.001178583333	0.0011852	0.001200975
80	40th percentile	0	0	0	0.0004	0.0006	0.0007	0.000825	0.0008857142857	0.00092	0.00097	0.0010225	0.001041428571	0.0010585	0.001082	0.001110125	0.001169714286	0.0012365	0.001235958333	0.001237033333	0.00125895
81	Median	0	0	0	0.0006	0.0007	0.00085	0.000925	0.0009571428571	0.00099	0.001035	0.001075	0.001082857143	0.001095	0.001114	0.0011455	0.001291714286	0.0012727	0.001276208333	0.001288133333	0.001293275
82	60th percentile	0	0	0.001	0.0008	0.0009	0.001	0.00105	0.001057142857	0.00108	0.00112	0.0011325	0.001127142857	0.001139	0.0011505	0.0013295	0.001336642857	0.0013151	0.001341583333	0.001325733333	0.00133405
83	75th percentile	0.002	0.002	0.001	0.0012	0.0013	0.0013	0.001275	0.001242857143	0.00129	0.00127	0.00124	0.001214285714	0.001223	0.00127175	0.001517625	0.001424357143	0.0014312	0.00141625	0.001410633333	0.001402525
84	90th percentile	0.003	0.003	0.0025	0.0024	0.0022	0.0019	0.0018	0.001842857143	0.00171	0.00153	0.00144	0.001452857143	0.0025585	0.00203075	0.001681	0.00163	0.00159565	0.001568458333	0.001538833333	0.001518875
85	95th percentile	0.004	0.004	0.005	0.0034	0.0029	0.0026	0.0026	0.002157142857	0.00197	0.001755	0.0019525	0.003437142857	0.0029865	0.002149	0.00197225	0.001780142857	0.0016899	0.001685833333	0.001627266667	0.001607
86	98th percentile	0.01	0.01	0.0075	0.005	0.0075	0.0046	0.003125	0.002635714286	0.00255	0.0086675	0.0059125	0.003949285714	0.0031745	0.002786	0.002142625	0.001938071429	0.0018605	0.001851375	0.001770766667	0.001801125
87	99th percentile	0.013	0.013	0.011	0.0152	0.0084	0.0051	0.003525	0.0035	0.016805	0.0108325	0.00614125	0.004087142857	0.0033205	0.00300075	0.0024155	0.00214	0.00202275	0.002086458333	0.0107945	0.0086129
88
89	month	90	10	20	50	100	200	400	700	1000	2000	4000	7000	10000	20000	40000	70000	100000	120000	150000	200000
90	1st percentile	0	0	0	0	0	0.0001	0.000275	0.0004	0.00048	0.000605	0.0007125	0.0007814285714	0.000828	0.00090125	0.00095475	0.0009863571429	0.001012	0.001019083333	0.001031333333	0.00104895
91	2nd percentile	0	0	0	0	0	0.0002	0.000325	0.0004428571429	0.00052	0.00065	0.0007425	0.0008092857143	0.0008535	0.0009205	0.00097	0.001000357143	0.00102555	0.001032416667	0.001043933333	0.001061125
92	5th percentile	0	0	0	0	0	0.00025	0.000425	0.0005142857143	0.00059	0.00071	0.0007925	0.0008542857143	0.000893	0.00095075	0.0009965	0.001025214286	0.0010437	0.001053083333	0.001064933333	0.001092075
93	10th percentile	0.0002	0	0	0	0.0002	0.00035	0.0005	0.0006	0.00066	0.000765	0.0008425	0.0008957142857	0.00093	0.00098275	0.00102125	0.001045928571	0.001066	0.00107725	0.001093866667	0.00113475
94	25th percentile	0.0004	0	0	0.0004	0.0004	0.00055	0.000675	0.0007571428571	0.0008	0.000875	0.00094	0.0009742857143	0.001004	0.001037	0.001067875	0.001093571429	0.0011326	0.001178583333	0.0011852	0.001200975
95	40th percentile	0.0006	0	0	0.0004	0.0006	0.0007	0.000825	0.0008857142857	0.00092	0.00097	0.0010225	0.001041428571	0.0010585	0.001082	0.001110125	0.001169714286	0.0012365	0.001235958333	0.001237033333	0.00125895
96	Median	0.0007	0	0	0.0006	0.0007	0.00085	0.000925	0.0009571428571	0.00099	0.001035	0.001075	0.001082857143	0.001095	0.001114	0.0011455	0.001291714286	0.0012727	0.001276208333	0.001288133333	0.001293275
97	60th percentile	0.0009	0	0.001	0.0008	0.0009	0.001	0.00105	0.001057142857	0.00108	0.00112	0.0011325	0.001127142857	0.001139	0.0011505	0.0013295	0.001336642857	0.0013151	0.001341583333	0.001325733333	0.00133405
98	75th percentile	0.0013	0.002	0.001	0.0012	0.0013	0.0013	0.001275	0.001242857143	0.00129	0.00127	0.00124	0.001214285714	0.001223	0.00127175	0.001517625	0.001424357143	0.0014312	0.00141625	0.001410633333	0.001402525
99	90th percentile	0.0022	0.003	0.0025	0.0024	0.0022	0.0019	0.0018	0.001842857143	0.00171	0.00153	0.00144	0.001452857143	0.0025585	0.00203075	0.001681	0.00163	0.00159565	0.001568458333	0.001538833333	0.001518875
100	95th percentile	0.0029	0.004	0.005	0.0034	0.0029	0.0026	0.0026	0.002157142857	0.00197	0.001755	0.0019525	0.003437142857	0.0029865	0.002149	0.00197225	0.001780142857	0.0016899	0.001685833333	0.001627266667	0.001607