Assignment:
The following data were collected on absorbance for the iron-bipyridyl complex as a function of iron concentration in parts per million. Seven groups undertook the experiment.
|
Iron concentration (ppm)
|
|
|
0.50
|
1.00
|
1.50
|
2.00
|
2.50
|
3.00
|
3.50
|
4.00
|
4.50
|
5.00
|
5.50
|
6.00
|
6.50
|
7.00
|
7.50
|
|
group A
|
0.01
|
0.08
|
0.23
|
0.32
|
0.40
|
0.48
|
0.57
|
0.63
|
0.75
|
0.80
|
0.89
|
0.96
|
1.04
|
1.12
|
1.19
|
|
group B
|
0.02
|
0.34
|
0.30
|
0.40
|
0.42
|
0.46
|
0.60
|
0.62
|
0.73
|
0.78
|
0.91
|
0.92
|
1.02
|
1.10
|
1.25
|
|
group C
|
0.12
|
0.13
|
0.20
|
0.34
|
0.65
|
0.67
|
0.76
|
0.55
|
0.72
|
0.76
|
1.03
|
0.95
|
1.00
|
1.23
|
1.20
|
|
group D
|
0.03
|
0.12
|
0.18
|
0.31
|
0.28
|
0.43
|
0.45
|
0.78
|
0.78
|
0.45
|
0.99
|
1.10
|
1.04
|
1.09
|
1.45
|
|
group E
|
0.15
|
0.34
|
0.28
|
0.45
|
0.36
|
0.52
|
0.54
|
0.62
|
0.89
|
0.80
|
0.89
|
0.98
|
1.10
|
1.12
|
1.18
|
|
group F
|
0.08
|
0.20
|
0.42
|
0.29
|
0.34
|
0.54
|
0.58
|
0.60
|
0.89
|
0.65
|
0.70
|
0.76
|
0.89
|
1.00
|
1.10
|
|
group G
|
0.22
|
0.22
|
0.26
|
0.22
|
0.50
|
0.56
|
0.59
|
0.59
|
0.63
|
0.80
|
0.90
|
0.92
|
1.01
|
1.16
|
1.10
|
Q1: In Excel calculate the mean and associated 95%CL for each concentration and then plot these data as an x-y graph, as shown below. Add the line of best fit and include the equation for the line and the coefficient of determination (R2) on the graph as shown below. Format the graph as shown below using font type ‘Times New Roman' and font size ‘12'. Import the graph to Word.
Q2: 1. Using the equation that is shown in the graph above calculate the absorbance that would be obtained for 10ppm iron
2. Using the equation that is shown in the graph above calculate the absorbance that would be obtained for 20ppm iron
3. If the absorbance reading was 2.00 what would be the concentration of iron in the sample?
4. If the absorbance reading was 3.00 what would be the concentration of iron in the sample?
5. What assumptions have you made in answering questions above.