Purchase Solution

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

Not what you're looking for?

Ask Custom Question

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
Purchase this Solution
Solution Summary

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

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

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

View More Free Quizzes
Related BrainMass Solutions

  • Wavelength and Absorbace

    The molar absorptivity for the complex at this wavelength is 2.45×104 L/(mol•cm). What is the absorbance of CoL3+ in this solution? Most of the data in this problem is unnecessary.

  • Concentration of Iron in a Waste Stream

    107190 Concentration of Iron in a Waste Stream The determination of iron in industrial waste stream is often carried out by reacting the water sample with o-phenanthroline to form a red-orange complex that absorbs at 510 nm.

  • light absorber of iron complex reaction

    187636 Light Absorber of Iron Complex Reaction What species are we measuring the absorption of light for the following reaction? Fe3+ + SCN- <---> Fe(SCN)2+. The absorber of light is SCN-. It has absorbance at 480 nm.

  • Analysis of Kinetics of the Reaction of Pt(bipy)Cl2 with en

    Use the data in Table 1 to calculate the absorbance at each time caused by Pt(bipy)Cl2 (iv) Plot your new absorbance data against time. Make sure you give your graph a title and label the axes.

  • Equilibrium Constant-Transition Metal Complex-Keq

    Given the following data prepare a Plot of Absorbane Vs [FeSCN2+] 6. What is the [FeSCN2+] at an absorbance of 0.35 from the standard curve? Please see the attached file. The Equilibrium Constant-Transition Metal Complex-Keq is investigated.

  • Beer's Law Lab - Light Absorption of Colored Solutions

    Make a plot of absorbance readings for each of the solutions vs. wavelength. (how can I create a plot, using what technology and if I do this right will it be a linear equation?) 2.

  • To calculate protein concentration with given absorbance

    Analyse the data, plot a suitable graph and determine the protein concentrations of the unknowns Protein standard (mg cm-3) Absorbance at 540nm 0 0.00 1

  • Plotting Absorbance against analyte Concentration

    There is also link you may fins helpful for the LINEST function Plotting Absorbance data against analyte Concentration and extracting key information - see question

  • Statistical Method (Concentration and Absorbance)

    Plot concentration as a function of absorbance: plot absorbance on the x axis and concentration on the y-axis; one plot for lead and one for barium. b.

View More Related Solutions