Copy of Dream Stream Barter + Unaccounted for streams

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W
1
2						Soul Sand	Crying Obsidian	Obsidian	Nether Brick	Leather	Gravel	Fire Charge	String	Ender Pearl	Magma Cream	Glowstone Dust	Nether Quartz	Fire rez	S. Fire rez	Iron nugget	Iron Boots	Book	Unknown
3					p =	40/423	40/423	40/423	40/423	40/423	40/423	40/423	20/423	20/423	20/423	20/423	20/423	10/423	10/423	10/423	8/423	5/423	-
4		Time stamp	Session	Ingots Traded	% chance	9.46%	9.46%	9.46%	9.46%	9.46%	9.46%	9.46%	4.73%	4.73%	4.73%	4.73%	4.73%	2.36%	2.36%	2.36%	1.89%	1.18%	-
5
6		26m50s	1	22		2	1	2	1	2	2		1	3		1			2				5
7		1h13m10s	1	5				1		1				2									1
8		2h12m12s	1	24		2	2	3	2	1	2	3		2	1	1			2				3
9		2h44m58s	1	18		1		3	1	3	2	1	1	2	1	1	1					1
10		18m	2	4		1						1						1		1
11		1h48m	2	1										1
12		2h05m45s	2	7			1		1					2			1		1	1
13		3h03m13s	2	12							1	1		4	1		1				1		3
14		4h06m30s	3	26		2	4	3	1	1	1	1	1	3	2	1	1						5
15		4h38m18s	3	8				1		1				2			1						3
16		5h56m27s	3	5							1		1	2		1
17		51m20s	4	21			2	2		1	3	1		2		1	1		1	1			6
18		2h39m32s	4	2											1				1
19		3h03m15s	4	13			2	1		1	1		1	1		2						1	3
20		3h32m53s	4	10		2	1	1			1	1	1	2	1
21		4h49m36s	4	10			1				1	1		2		1				1			3
22		5h19m	4	21		1	2	4	3	2	3	1		2			1						2
23		14m	5	20		1		1	1	1	1	2	2	2	3			2		1			3
24		1h51m15s	5	10		2			1		2			2			1						2
25		3h01m24s	5	3		1				1				1
26		13m30s	6	18		1	1	2			4	1	1	2			1	1			1	1	2
27		53m38s	6	3			1							2
28			Total:	263		16	18	24	11	15	25	14	9	41	10	9	9	4	7	5	2	3	41
29					Expected Value:	24.86997636	24.86997636	24.86997636	24.86997636	24.86997636	24.86997636	24.86997636	12.43498818	12.43498818	12.43498818	12.43498818	12.43498818	6.21749409	6.21749409	6.21749409	4.973995272	3.108747045
30			Total %:			6.08%	6.84%	9.13%	4.18%	5.70%	9.51%	5.32%	3.42%	15.59%	3.80%	3.42%	3.42%	1.52%	2.66%	1.90%	0.76%	1.14%
31
32			std dev. sqrt[(np(1-p))]			4.745335135	4.745335135	4.745335135	4.745335135	4.745335135	4.745335135	4.745335135	3.44195373	3.44195373	3.44195373	3.44195373	3.44195373	2.463840176	2.463840176	2.463840176	2.209055101	1.752712363
33
34			z-score (x-expected)/std dev.			-1.869199141	-1.447732597	-0.1833329648	-2.922865501	-2.079932413	0.02740030724	-2.290665685	-0.9979762802	8.299069094	-0.7074436123	-0.9979762802	-0.9979762802	-0.9000153952	0.317596051	-0.4941449131	-1.346274826	-0.06204500364
35
36
37
38
39
40
41		(TY to whoever made this spredsheet)
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63	Stream Link	Gold Given	Pearl Trades	NoPearlTrades		Notes		Time trading
64
65	19th Stream	41	3	38
66	20st Stream	107	3	104
67	21st Stream	44	1	43			12:46	14:45	1:00:00	2:06
68	22nd	153	5	149		(Around 130+ trades with no pearls)	19:46	1:37:06	2:37:00	(Receives pearl 2:41:08)		3:50:00
69	23rd	5	0	5
70
71
72	Unnacounted Streams			Combined with accusatory streams				natekomodo was here
73	Total trades	350		Total	613			justin was here
74	Probability	0.03428571429		Probability	8.65%
75	Total Pearls	12		Total Pearls	53
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100