University of New Hampshire Biochemistry Lab Report

1. Use your initial rate data for the LDH assays to prepare initial rate plots.a) Start with a blank worksheet and enter the time and OD340 for each of your samples in
adjacent columns. Submit the table that you created with your report.
b) Create an xy scatter chart to display the initial rate of each LDH assay (y-axis: OD340, xaxis: time (sec). [See graph below]
c) Add a trendline (linear) and select the option to show the regression coefficients (y= m*x
+ b). Also add an r2 value to the chart. Format the trendline in scientific notation with 2
decimal places. If the later time points deviate from linearity, choose only the initial points
that fit a straight line to make your trendline. Submit your xy scatter charts with your report
to receive credit for this portion of the report. You can add multiple data sets to a single
chart.
d) From the slope of the line, you
obtain the initial rate in units of
OD340/sec.
e) Average the initial rates for each
of the duplicate assays for a given
volume tested.
2. (5 pts) Create a table with two
columns; one for LDH volume tested and
the second for the average initial rate
(OD/sec) from the two trials.
3. (10 pts)Using the table created in #2 above, create an xy scatter chart with Average OD/sec
on y-axis and LDH volume (in µl) on the x axis. Give the chart a title and label both axes.
4. (25 pts) Add a linear trendline to the graph created in #3. Evaluate whether your data fits a linear
model or whether some other type of curve better represents the dependence of LDH activity on
enzyme concentration. Discuss how the reaction rate is related to the amount of enzyme present in
the reaction. Submit table and chart with your lab report