Consider the following data set: Sample Corrected Absorbance at 470 nm 100 ug/ml CuSO. standard 200 ug/mL CuSO. standard 300 ug/ml Cuso. standard 0.032 0.058 0.090 400 ug/ml CuSO. standard 500 ug/ml Cuso. standard CusO. Solution with Unknown Concentration 0.114 0.140 0.070 1. Plot (Using MS Excel) or draw by hand a standard calibration curve for samples 1 to 5. Determine the molar absorptivity using the absorbance of the 100 ug/mL CuSo, standard. (Note: Convert ug/ml to Molarity first using the molar mass of the standard which is 249.685 g/mol). l 2. Write the resulting linear regression equation and R of the plotted standard calibration curve. 3. Calculate the concentration of the "CuSO. Solution with Unknown Concentration" using the produced linear regression equation from the standard calibration curve and its absorbance at 470 nm.

Consider the following data set: Sample Corrected Absorbance at 470 nm 100 ug/ml CuSO. standard 200 ug/mL CuSO. standard 300 ug/ml Cuso. standard 0.032 0.058 0.090 400 ug/ml CuSO. standard 500 ug/ml Cuso. standard CusO. Solution with Unknown Concentration 0.114 0.140 0.070 1. Plot (Using MS Excel) or draw by hand a standard calibration curve for samples 1 to 5. Determine the molar absorptivity using the absorbance of the 100 ug/mL CuSo, standard. (Note: Convert ug/ml to Molarity first using the molar mass of the standard which is 249.685 g/mol). l 2. Write the resulting linear regression equation and R of the plotted standard calibration curve. 3. Calculate the concentration of the "CuSO. Solution with Unknown Concentration" using the produced linear regression equation from the standard calibration curve and its absorbance at 470 nm.

Appl Of Ms Excel In Analytical Chemistry

2nd Edition

ISBN:9781285686691

Author:Crouch

Publisher:Crouch

Chapter4: Least-squares And Calibration Methods

Section: Chapter Questions

Problem 9P

See similar textbooks

Similar questions

Mass spectrometry is an extremely versatile detection system for GC. However, interfacing an HPLC system to a mass spectrometer is a much more difficult task. Describe the major reasons why it is more difficult to combine HPLC with mass spectrometry than it is to combine GC with mass spectrometry.
1. Data & Results 4.0 mglmL Concentration of stock solution (include units): Table 1-Beer's Law Plot Data V Volume of standard solution dispensed (mL) M, Diluted concentration (include units) Sample Absorbance A 2.00 mL 0.084 4.00 mL 0.173 l6.00 mL 0.259 8.00 mL 0.340 E 10.00 mL 0.418 Equation of trendline from Beer's Law plot: whats the diluted concentration and equation of trendline from the beers law plot once created?
Please create a caption for this table. Solution NaCl Conc. (%) Osmolality (mOsm) % transmittance Absorbance % hemolysis % crenation C distilled 0 0 0.001029 4.987584625 100 0.03354 1 0.177179111 54.61 0.001551 4.809388202 96.42720001 0.05837 2 0.297126222 91.58 0.01012 3.994819487 80.09527231 0.08444 3 0.442542222 136.4 3.849 1.414652089 28.3634704 0.134 4 0.590164444 181.9 64.8 0.188424994 3.777880643 0.2125 5 0.74752 230.4 95.64 0.019360433 0.388172513 0.3368 6 0.89644 276.3 99.56 0.001915112 0.038397585 0.5336 7 1.095648889 337.7 99.98 8.68676E-05 0.001741676 0.9834 8 1.336711111 412 100 0 0 2.1 9 1.755568889 541.1 100 0 0 7.9 10 2.674395556 824.3 100 0 0 57.83 11 4.490211111 1384 100 0 0 99.72
3. The lead in a swab sample, lead standards, together with a blank were made up in 5.00 mL volumetric flasks using 0.2 % HNO3. 20 μL aliquots of these solutions were injected into the spectrophotometer and the absorbance measured at 217 nm. The following results were obtained. lead / ppb Absorbance 0 0.0591 10.00 0.0858 50.00 0.1926 100.0 0.3260 150.0 0.4594 200.0 0.5929 Swab sample 0.3700 (a) Determine the amount of lead in the swab sample in μg.
Based on the data, calculate the concentration of analyte in the ORIGINAL sample in ppm. Report to 1 decimal place Sample: A 10.00 mL aliquot of the unknown was placed in a 100.0 mL volumetric flask and made up to the mark will distilled water. The absorbance of this solution is 0.185. Sample + Spike: A 10.00 mL aliquot of the unknown and a 13.00 mL aliquot of the 46.00 ppm stock were both placed in the same 100.0 mL volumetric flask and diluted to the mark with water. The absorbance of this solution is 0.326. ( Please type answer note write by hend)
The spectrophotometer is set at 600 nm. The absorbance of each cuvette is read. The data is shown below: Cuvette 1 is the clank Cuvette # ml albumin Absorbance 0. 0.2 .063 3 0.4 .163 4. 0.6 .187 0.8 .253 1.0 .289 Using this data, plot an Excel graph showing absorbance (y-axis) vs ml albumin (x-axis). Find the correlation coefficient (r). R2 > 0.99 = excellent data; r2 0.98-0.95 good data r2 0.94 -0.90 = fair data. How would you describe this data?- To find the relative sensitivity, for each of tubes 2-6 (neglect blank), perform the following operation absorbance (Lowry)/Absorbance (Biuret x 0.5 gram albumin (Biuret)/0.05 gram (Lowry) x 200 ml (Lowry)/100 mL (Biuret). This implifies to Relative sensitivity = 20 dilution factor x absorbance (Lowry)/Absorbance (Biuret). Report your relative sensitivity as an average of all 5 values.
A student weighed out 0.150 g of protein powder and dissolved it in 100 mL of water (Solution 1). The student then diluted this solution by transferring 1 mL into a 25 mL flask and diluting with water (Solution 2). Finally, 1 mL of that solution was transferred to a test tube and combined with 4 mL Bradford reagent. The absorbance of the solution in the test tube was 0.144. Assuming that the best fit linear line of the standard curve was y=0.04144x+0.01521 (μgmL), calculate the percent protein by mass in the original protein powder.
SPECTROPHOTOMETRY 1.) Slope of regression line or Molar absorptivity (µM -1cm-1) is 0.0253 and absorbance of unknown solution is 0.131. What is the concentration of the unknown solution (µM )?
What value of absorbance corresponds to 45.0% T?
PART ONE: Preparation of FECNS* Solution Prepare the two solutions in table 1 by accurately measuring the required volumes of distilled water and CNS into two labeled test tubes. The absorbance of the solutions must be measured soon after adding the Fe" solution from a buret. TABLE 1 Fe 5 ml 5S mL Solution Distilled Water CNS 2 mL Total Volume 3 ml 2 ml 10 ml 3 mL 10 ml In this part of the experiment you are to explore what the above quote means. As a PRELIMINARY Exercise, formulate a hypothesis as to what would happen under each of the following circumstances: 1. 1ml of 0.0020 M CNS' solution is added to the unused portion of solution 1 in the test tube 2. One drop of 0.20 M CNS solution is added to the unused portion of solution 2 in the test tube.
How do I find Concentration? flask Calculate solution Concentration (M) Volume stock of 0.40 M CuSO4 (ml) Volume of flask (ml) Absorbance at 635 nm(a.u.) 1 2.0 10 .185 2 4.0 10 .362 3 6.0 10 .510 4 8.0 10 .674 5 10.0 10 .843
only assign peaks from 1500 to 2000 cm-1