Assignment 4 data (1).xlsx

	A	B	C	D	E	F	G	H	I	J
1	Lab 5 data (Samples were collected and tested on March 4 2019 - see map on the left)
2				Acidity test			Alkalinity test		Hardness test
3	Site	Sample	pH	sample volume (mL)	0.02 N H2SO4 used to bring pH <4 (mL)	0.02 N standard NaOH titrant used (mL)	sample volume (mL)	0.1 N standard H2SO4 titrant used (mL)	sample volume (mL)	0.02 N standard EDTA titrant used (mL)
4	Site 1	Rep 1	8.75	50.0	12.46	0.04	50.0	2.10	25.0	7.19
5		Rep 2	8.75	50.0	11.48	0.02	50.0	2.29	25.0	7.03
6		Rep 3	8.75	50.0	11.76	0.09	50.0	2.24	25.0	7.05
7	Site 2	Rep 1	8.28	50.0	12.00	0.00	50.0	2.29	25.0	6.21
8		Rep 2	8.28	50.0	12.00	0.10	50.0	2.60	25.0	6.89
9		Rep 3	8.27	50.0	12.21	0.05	50.0	2.35	25.0	7.00
10	Site 3	Rep 1	8.53	50.0	12.53	0.02	50.0	2.26	25.0	6.67
11		Rep 2	8.50	50.0	13.04	0.02	50.0	2.33	25.0	7.17
12		Rep 3	8.47	50.0	13.28	0.09	50.0	2.34	25.0	7.82
13	Site 4	Rep 1	8.48	50.0	9.00	0.10	50.0	1.56	25.0	4.40
14		Rep 2	8.43	50.0	8.00	0.10	50.0	1.44	25.0	4.51
15		Rep 3	8.44	50.0	8.00	0.05	50.0	1.44	25.0	4.39
16	Site 5	Rep 1	6.72	50.0	11.80	0.05	50.0	1.60	25.0	4.90
17		Rep 2	6.93	50.0	8.50	0.05	50.0	1.60	25.0	5.20
18		Rep 3	7.01	50.0	8.90	0.05	50.0	1.60	25.0	5.00
19
20	Labs 6 & 7 data (Samples were collected and tested on March 22 2019 - see map on the left)
21	Orthophosphate (PO43-) analysis		Absorbance @ 690 nm
22	Orthophosphate (PO43-) analysis	standard (mg PO43--P/L)		site 1	site 2	site 3	site 4	site 5
23	DI water		0.02
24	std1	0.005	0.026
25	std2	0.010	0.028
26	std3	0.050	0.052
27	std4	0.100	0.067
28	std5	0.200	0.179
29	sample rep 1			0.026	0.025	0.023	0.019	0.012
30	sample rep 2			0.022	0.028	0.021	0.020	0.01
31	sample rep 3			0.022	0.026	0.018	0.019	0.009
32
33	Nitrate (NO3-) analysis		Absorbance @ 520 nm
34	Nitrate (NO3-) analysis	standards (mg NO3--N/L)		site 1	site 2	site 3	site 4	site 5
35	DI water		0.027
36	std1	0.200	0.087
37	std2	0.500	0.214
38	std3	1.000	0.798
39	std4	2.000	1.401
40	std5	4.000	2.689
41	sample rep 1			0.522	1.600	0.727	0.162	0.610
42	sample rep 2			0.605	2.007	0.725	0.100	0.428
43	sample rep 3			0.503	1.694	0.623	0.102	0.427
44
45	Nitrate (NO2-) analysis		Absorbance @ 520 nm
46	Nitrate (NO2-) analysis	standards (mg NO2--N/L)		site 1	site 2	site 3	site 4	site 5
47	DI water		0.027
48	std1	0.020	0.018
49	std2	0.050	0.038
50	std3	0.100	0.084
51	std4	0.150	0.128
52	std5	0.200	0.193
53	sample rep 1			0.021	0.020	0.032	0.025	0.031
54	sample rep 2			0.016	0.023	0.030	0.024	0.032
55	sample rep 3			0.027	0.019	0.027	0.024	0.026
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