Workup of beads question.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	U	X	Y	Z
1	Bead sinking data											I rearange the data based on bead size and make sure values are in appropriate units
2
3	The Avocado Toast	Bead Size	Bead Diameter	Bead Mass	Sinking Time (1)	Sinking Time (2)	Sinking Time (3)	Sinking Speed(1)	Sinking Speed (2)	Sinking Speed (3)		Bead 1	Bead 2	Bead 3	Bead 4	Bead 5
4	List Student Names Below:	Size 1 smallest	3.2	0.13	6.78	6.53	6.56	4.94	5.13	5.11		size (mm)
5	Vienna Melzl	Size 2	4.7	0.43	3.31	3.22	3.34	9.94	10.4	10.03		3.2	4.7	6.3	9.5	12.7
6	Grace Copeland	Size 3	6.3	1.03	1.81	1.97	1.97	17.91	17.01	17.01		2.8	4.7	6.39	9.5	12.7
7	Liana Jones	Size 4	9.5	3.51	1.03	1.03	1	32.52	32.52	33.5		2.9	4.6	6.2	9.5	12.7
8		Size 5 largest	12.7	8.36	0.65	0.66	0.65	55.54	50.76	55.54		3.1	4.7	6.3	9.2	12.7
9												1.5	3.5	5	8.1	11.2
10											mean	2.7	4.4	6.0	9.2	12.4
11	Team Name: Hammerheads	Bead Size	Bead Diameter	Bead Mass	Sinking Time (1)	Sinking Time (2)	Sinking Time (3)	Sinking Speed(1)	Sinking Speed (2)	Sinking Speed (3)	median	2.9	4.7	6.3	9.5	12.7
12	List Student Names Below:	Size 1 smallest	2.8	0.14	6.79	6.5	6.53	49.34	51.54	51.3	standard dev	0.7	0.5	0.6	0.6	0.7
13	Brett	Size 2	4.7	0.43	3.25	3.31	3.28	103.08	101.2	102.13	percentile dif	0.4	0.2	0.3	0.3	0.3
14	Matt	Size 3	6.39	1.02	2.09	2.03	1.97	160.29	165.02	170.05	maximum	3.2	4.7	6.4	9.5	12.7
15		Size 4	9.5	3.46	1.03	1.06	1.04	325.24	316.04	322.12	minimum	1.5	3.5	5.0	8.1	11.2
16		Size 5 largest	12.7	8.36	0.72	0.63	0.72	465.28	531.74	465.28	16th percentile	2.3	4.2	5.8	8.8	12.2
17											84th percentile	3.1	4.7	6.3	9.5	12.7
18
19	Team Name: Hyperoptical	Bead Size	Bead Diameter	Bead Mass	Sinking Time (1)	Sinking Time (2)	Sinking Time (3)	Sinking Speed(1)	Sinking Speed (2)	Sinking Speed (3)		sinking speeds (cm/s)
20	List Student Names Below:	Size 1 smallest	2.9	0.13	6.56	8	6.96	0.05106707317	0.041875	0.04813218391		4.94	9.94	17.91	32.52	55.54
21	Charlotte	Size 2	4.6	0.45	3.15	3.22	3.34	0.1063492063	0.1040372671	0.1002994012		5.13	10.40	17.01	32.52	50.76
22	Patrick	Size 3	6.2	1.03	2.03	2.09	1.97	0.1650246305	0.1602870813	0.1700507614		5.11	10.03	17.01	33.50	55.54
23	Lexi (?)	Size 4	9.5	3.46	1	1	0.69	0.335	0.335	0.4855072464		4.93	10.31	16.03	32.52	46.53
24		Size 5 largest	12.7	8.35	0.66	0.69	0.62	0.5075757576	0.4855072464	0.5403225806		5.15	10.12	16.50	31.60	53.17
25												5.13	10.21	17.01	32.21	46.53
26												5.11	10.63	16.50	33.50	50.76
27	Team Name: J	Bead Size	Bead Diameter	Bead Mass	Sinking Time (1)	Sinking Time (2)	Sinking Time (3)	Sinking Speed(1)	Sinking Speed (2)	Sinking Speed (3)		4.19	10.40	16.03	33.50	48.55
28	List Student Names Below:	Size 1 smallest	0.31cm	0.13g	6.88s	6.84s	6.50s	0.0497 m/s	0.05m/s	0.0526 m/s		4.81	10.03	17.01	48.55	54.03
29	Justin	Size 2	0.47cm	0.43g	0.43g	3.65s	3.28s	0.11m/s	0.094m/s	0.104m/s		4.97	11.00	17.40	32.00	40.70
30	Jeremy	Size 3	0.63cm	1.02g	1.02g	2.07s	2.00s	0.174m/s	0.165m/s	0.171m/s		5.00	9.40	16.50	29.50	52.60
31		Size 4	0.92cm	3.42g	3.42g	1.16s	1.03s	0.320m/s	0.295m/s	0.332m/s		5.26	10.40	17.10	33.20	49.60
32		Size 5 largest	1.27cm	8.17g	8.17g	0.65s	0.69s	0.407m/s	0.526m/s	0.496m/s		5.00	9.90	15.98	26.70	46.60
33												4.85	10.60	15.55	32.70	44.80
34												5.11	10.35	14.71	28.70	46.60
35	Team Name: The Leftovers	Bead Size	Bead Diameter	Bead Mass	Sinking Time (1)	Sinking Time (2)	Sinking Time (3)	Sinking Speed(1)	Sinking Speed (2)	Sinking Speed (3)	mean	4.98	10.25	16.55	32.88	49.49
36	Lars	Size 1 smallest	1.5mm	0.12g	7s	7.2s	6.84s	5cm/s	4.85cm/s	5.11cm/s	median	5.00	10.31	16.50	32.52	49.60
37	Lilly	Size 2	3.5mm	0.44g	3.53 s	3.2s	3.38s	9.9cm/s	10.6cm/s	10.35cm/s	standard dev	0.25	0.38	0.80	4.76	4.27
38		Size 3	5 mm	1.03g	2.19 s	2.25s	2.38s	15.98 cm/s	15.55cm/s	14.71cm/s	percentile dif	0.13	0.30	0.54	1.75	3.65
39		Size 4	8.1 mm	3.47 g	1.31 s	1.07 s	1.22s	26.7cm/s	32.7cm/s	28.7cm/s	maximum	5.26	11.00	17.91	48.55	55.54
40		Size 5 largest	11.2 mm	8.19g	0.75s	0.78s	0.75s	46.6cm/s	44.8cm/s	46.6cm/s	minimum	4.19	9.40	14.71	26.70	40.70
41											16th percentile	4.87	9.96	15.99	30.00	46.53
42											84th percentile	5.13	10.55	17.08	33.50	53.83
43
44						B. Median and mean are preety close.
45						Standard deviation and percential difference are also similar for most beads (not for bead 4)
46						D. There seems to be a relation between sinking and cross-section but it is not perfectly linear (there is curvature).
47
48																	median diameter (mm)	Cross-secition (mm^2)	Median sinkin speed (cm/s)	uncertainty in sinking (percentile dif, cm/s)	uncertainty in median diameter	uncertainty in cross section
49																	2.9	6.6	5.00	0.13	0.40		1.294878232
50																	4.7	17.3	10.31	0.30	0.25		1.29
51																	6.3	31.2	16.50	0.54	0.28		1.97
52																	9.5	70.9	32.52	1.75	0.35		3.67
53																	12.7	126.7	49.60	3.65	0.27		3.81
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
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