Share
Explore BrainMass

Plot and Analyze Data: Absorbance for the Iron-Bipyridyl Complex

Please see attached file for the data.

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.

Question 1

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.

Question 2

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.

Attachments

Solution Preview

** Please see the attached file for the complete solution response **

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

Question 1

In Excel ...

Solution Summary

This solution provides a detailed a computation of the given accounting problem.

$2.19