Workup of rod question.xlsx

	A	B	C	D	E	F	G	H	I	L
1	I used the data from the Avocado toasts
2	Rod	1	2	3	4	5	6	7	8
3	mass (g)	3.65	5.36	5.11	7.12	6.56	8.89	10.98	14.29
4	length (cm)	2.4	2.9	3.4	3.9	4.4	4.9	7.4	7.9
5	diameter (mm)	12.76	12.71	12.75	12.71	12.76	12.7	12.75	12.71
6
7	uncertainties in measurements (note, I may be different in these values compared to your uncertainties)
8	d_mass	0.005g
9	d_length	0.5mm	0.05cm
10	d_diameter	0.5mm	0.05cm
11
12	Use volume of a cylinder formulat to compute volume and ratio of mass to volume to compute density)
13	Volume (cm^3)	3.07	3.68	4.34	4.95	5.63	6.21	9.45	10.02
14	Density (g/cm^3)	1.19	1.46	1.18	1.44	1.17	1.43	1.16	1.43
15
16	Use error propagation formulas to obtain uncertainties in volume and in density
17	d_volume (cm^3)	0.07	0.07	0.07	0.07	0.07	0.07	0.08	0.08
18	d_density (g/cm^3)	0.03	0.03	0.02	0.02	0.01	0.02	0.01	0.01
19
20	Plotting: segregate data by density
21	Mass (g)	Volume (cm^3)	d_mass (g)	d_volume (cm^3)
22	3.65	3.07	0.005	0.07						1.18929719
23	5.11	4.34	0.005	0.07						1.177149797
24	6.56	5.63	0.005	0.07						1.165896323
25	10.98	9.45	0.005	0.08						1.162145138
26
27	5.36	3.68	0.005	0.07						1.456752625
28	7.12	4.95	0.005	0.07						1.438912562
29	8.89	6.21	0.005	0.07						1.432215461
30	14.29	10.02	0.005	0.08						1.425686887
31
32
33
34
35	Error bar are smaller than symbol
36
37	The slope of the line represents the density (= Mass / Volume) in units of g/cm^3
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
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