Explore BrainMass

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

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

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?

https://brainmass.com/statistics/normal-distribution/plot-analyze-data-absorbance-iron-bipyridyl-complex-361354

#### 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