Explore BrainMass

Explore BrainMass

    Plotting Absorbance against analyte Concentration

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

    The data in the table below were obtained during a colorimetric determination of glucose in blood serum.

    Glucose Absorbance,
    concentration, NM A
    0.0 0.002
    2.0 0.150
    4.0 0.294
    6.0 0.434
    8.0 0.570
    10.0 0.704

    (a) Assuming a linear relationship, find the least-squares estimates of the slope and intercept.
    (b) Use the LINEST function in Excel to find the standard deviations of the slope and intercept. (See S.R. Crouch and F.J. Holler, Applications of Microsoft® Excel in Analytical Chemistry, Belmount, CA: brooks/Cole, 2004, Chap.4) What is the standard error of the estimate?
    (c) Determine the 95% confidence intervals for the slope and intercept.
    (d) A serum sample gave an absorbance of 0.350. Find the glucose concentration and its standard deviation.

    © BrainMass Inc. brainmass.com June 3, 2020, 10:20 pm ad1c9bdddf

    Solution Summary

    Plotting Absorbance data against analyte Concentration and extracting key information - see question