# Lab Report: Relationship between Concentration and Absorbance

**Topics:**Chemistry, Concentration, Linear regression

**Pages:**3 (534 words)

**Published:**February 24, 2013

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)

Follow instructions in:...

Please join StudyMode to read the full document