# Lab Report: Relationship between Concentration and Absorbance

Pages: 3 (534 words) Published: February 24, 2013
involves measuring the absorbance of several concentrations of the pure substance or the "standard" substance

determine relationship between concentration and absorbance

compared results from unknowns
How to use Linear Regression for
Generating a Standard Curve?
© 2010 by M. Olaveson UTSC
2
BIO A01F-Fall 2010 - ASSIGNMENT # 2 - Preparing a Standard Curve using Excel 2007

Assignment # 2
Analysis of Data from Lab 2-Exercise 2
Table 2.6. Protein in Test Tubes prepared for Standard Curve. 1. Follow instructions in Lab Manual and complete Table 2.6 © 2010 by M. Olaveson UTSC
3
BIO A01F-Fall 2010 - ASSIGNMENT # 2 - Preparing a Standard Curve using Excel 2007

Assignment # 2:
Table 2.7. Absorbance (at 550 nm) as a function of protein concentration. 2. Complete Table 2.7
© 2010 by M. Olaveson UTSC
4
BIO A01F-Fall 2010 - ASSIGNMENT # 2 - Preparing a Standard Curve using Excel 2007

5. After plotting XY Scatter Plot – perform a Linear Regression Analysis to generate a “line of best fit’ by using the “Trendline” option

Determine the Equation for the Line and the Correlation Coefficient (R2 Value) by clicking the options in the “Trendline” menu: - choose “intercept = 0”
- choose “show equation”
choose show “R2 value”
Use Equation to determine the protein concentration in the Unknown Sample (make sure to indicate Unknown #)

Complete Assignment # 2 according to Instructions on Blackboard under “Assignments – Assignment # 2” and submit to your TA at beginning of Lab 3 © 2010 by M. Olaveson UTSC
6
BIO A01F-Fall 2010 - ASSIGNMENT # 2 - Preparing a Standard Curve using Excel 2007 Assignment # 2:
From Table 2.7 – use the Protein Concentration and
corresponding Absorbance (at 550 nm) to plot an XY Scatter Plot (using Excel / Star Office / Graphing Program)

HINT: graphing options are found in the Chart Function in Excel (use Chart Wizard)