Assignment 3 data (1).xlsx

	A	B	C	D	E	F	G	H	I	J
1	Please read the manuals for Lab 3 and Lab 4 for sampling sites and procedures for the data collected on the following dates in spring 2020
2					Lab 3 (Friday, Feb 28 2020 data)				Lab 4 (Friday, Feb 28 2020 data)
3									Modified Winkler Method for DO measurement
4									Samples collected following EPA protocol	Samples collected NOT following EPA protocol (see table 1 of Lab 4 manual)
5		site	Replicate	Temperatuure (oC)	Conductivity (uS)	TDS (mg/L)	Turbidity (NTU)	location (coordinates)	volume of titrant (mL)	volume of titrant (mL)
6	Group 1	S1	1	9.10	800	570	4.85	37.2281	1.75	1.76
7	(meter 1)		2	9.10	790	570	4.69	-80.4274	1.78	1.79
8			3	9.10	790	570	3.76		1.85	1.60
9	Group 2	S2	1	10.50	785	560	1.32	37.2257	2.38	2.90
10	(meter 2)		2	10.50	786	560	0.86	-80.4257	1.77	3.01
11			3	10.50	780	560	1.16		2.02	3.15
12	Group 3	S3	1	10.02	780	560	1.25	37.1342	1.90	2.18
13	(meter 3)		2	9.98	780	560	1.36	"-80.2530	2.00	2.47
14			3	10.06	780	552	1.43		1.92	2.01
15	Group 4	S4	1	6.92	700	690	7.12	37.2245	2.11	3.04
16	(meter 4)		2	6.92	730	700	8.29	-80.4296	1.90	3.18
17			3	6.92	720	730	8.01		1.95	3.06
18	Group 5	S5	1	7.60	950	320	5.54		2.01	2.88
19	(meter 5)		2	7.60	950	320	5.43		2.02	1.72
20			3	7.60	950	320	5.82		2.02	2.05
21
22
23					Lab 3 (Monday, March 2 2020 data)
24
25		site	Replicate	Temperatuure (oC)	Conductivity (uS)	TDS (mg/L)	Turbidity (NTU)	location (coordinates)
26	Group 5	S1	1	10.10	1200	410	6.38	37.228
27	(meter 5)		2	10.10	1200	410	6.33	-80.4271
28			3	10.10	1200	410	6.73
29	Group 4	S2	1	11.40	870	620	5.43	37.2258
30	(meter 4)		2	11.40	870	620	4.77	-80.4259
31			3	11.40	880	620	5.05
32	Group 3	S3	1	11.16	772	550	2.45	37.2256
33	(meter 3)		2	11.16	780	552	1.55	-80.4271
34			3	11.18	780	550	1.24
35	Group 2	S4	1	6.80	740	510	8.05	37.1328
36	(meter 2)		2	6.80	750	510	6.96	-80.2547
37			3	6.80	750	510	6.66
38	Group 1	S5	1	8.10	780	560	4.32	37.1318
39	(meter 1)		2	8.10	780	560	4.12	-80.2552
40			3	8.10	780	560	4.11
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