Post-Lab 2 Assignment

.docx

School

McMaster University *

*We aren’t endorsed by this school

Course

1A03

Subject

Biology

Date

Dec 6, 2023

Type

docx

Pages

7

Uploaded by DrHummingbird3844

Report
BIO 1A03 Post-lab 2 Assignment – Aemen Obaid 1. Creating Your Standard Curve in Excel Using the data that you collected in Table 2.7, and the instructions provided in Excel Tutorial #2 (p. 109), create a scatter plot using Excel. You should only include the data for samples 0I, 5I, 10I, 15I, 20I, and 25I in your standard curve. Your independent variable is amylase concentration, and your dependent variable is absorbance. Follow the instructions in the tutorial to format your graph correctly as a publication quality figure. Add a line of best fit to the scatterplot. Add the equation of the line and make sure that the R 2 value is visible on the figure. This graph is your standard curve. (10 marks) 0 5 10 15 20 25 0 0.2 0.4 0.6 0.8 1 1.2 1.4 f(x) = − 0.04 x + 1.09 R² = 0.86 Absorbance Values for Amylase Concentration Standard Curve Amylase Concentration (µg/ml) Absorbance (620 nm) Figure 1. Standard curve created by plotting Amylase concentration against absorbance values. The line of best fit is y = -0.0439x +1.0871, and the R 2 value = 0.8576.
0 5 10 15 20 25 0 0.2 0.4 0.6 0.8 1 1.2 1.4 f(x) = − 0.04 x + 1.09 R² = 0.86 Amylase Concentration (µg/ml) Absorbance (620 nm) 2. Determine the concentration of Amylase in your Saliva Samples The standard curve can be used to determine the amylase concentration of your unknown samples since you measured the absorbance. The equation of the line in the format y = mx + b, can be used to calculate the unknown amylase concentration in your saliva. This can be accomplished by inputting the measured absorbance value of each unknown sample into the equation of the line and solving the equation to determine the amylase concentration in each of these tubes. Please remember to factor in the dilution of your saliva sample when calculating your Amylase conc (mg/ml) and if done correctly, your calculated concentration from the standard curve will be the same value for 10x, 100x and 1000x saliva samples. Please use your completed curve to determine the concentration of amylase in your unknown saliva samples. Please show your calculations for each dilution and your final calculated concentration to your TA. (3 marks) I could not use my 10x and 100x sample because the colour of the samples didn’t change when iodine was added; the solution remained yellow. This occurred because in the 10x and 100x samples, the amylase concentration was too concentrated, resulting in all of the starch being broken down (iodine had no starch to react with)
The absorbance value of the 1000x sample is negative because it is larger than the y- intercept on the standard curve (y-int = 1.0871), so it falls outside the scope of the assay. This means that the amylase became too dilutes and no/very little starch was broken down, resulting in a high absorbance value (iodine had lots of starch to react with). The 100x solution was too concentrated with amylase while the 1000 solution was too diluted to calculate the actual concentration of amylase in the saliva. Your saliva sample Amylase Conc (ug/mL) Amylase Conc (mg/mL) 10x, 100x and 1000x Y=mx+b -0.293849 3. Using the completed data Table 2.8 provided by your TA, with both amylase concentration and self-reported starch consumption from all your lab mates, create a 3-bar graph. Create as a publication-grade figure using 3 bars (low, moderate, high starch consumption on the x-axis and amylase concentration on the y-axis) with accompanying error bars. You will be creating two versions of the same figure. The data will remain the same, but one figure will have standard deviation error bars and the other figure will have range error bars. Instructions on how to do this assignment is detailed in Excel Tutorial #3 for Office 365 - Creating a Bar Graph with Error Bars (p. 119) (10 marks)
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help