preview

Ap Biology Spreadsheet

Decent Essays

First, it was downloaded the spreadsheet from eLearn provided by the instructor titled as “Experiment I data”. The first thing, it was calculated the slope for each Time point and Response set of data. It was noticed that inhibitor concentration [I] was constant, and substrate [S] concentration was increasing. So, it was used the Response vs. Time data to allowed to measure the initial velocity [Vo] of the enzyme converting substrate to product. It was typed the formula “=slope(“ in the shift cell called “slope”. When it was typed the formula, it was selected the Y-values which is the Response column dragged down until the last response. Then, put a comma to separate the X-values which is the Time column followed by a closed parenthesis. Since, slope should be calculated for all of the others, it can be save time by doing …show more content…

To do this plot, it was took the reciprocal of everything. The reciprocal formulas used was “=1/”. It was selected the cell and typed the formula, and then selected the cell need it to do reciprocal of. It was started with B40, so it was like “=1/B40”. Since data was organized, it was used the black cross again to spread the formula around the other cells in the data set. It was repeated the same produce for I=5, 15, and 20 and for Inhibitor 2, and 3 to yield all to have the double reciprocal data. Finally, by doing these 3 graphs, can be calculated the Km and Vmax for each inhibitor concentration. To allow to do this, it was selected Chart, but now it was used Marked Scatter plots because this does not allow to connect the points. After, it was added the four inhibitor concentrations, added labels to the X and Y-axis, given a title, and selected Add Trendline. Then, it was selected “Display equation on the chart” and under Forescast was changed into 0.1 Periods in Backwards. This allowed to see where the X and Y-axis hit, and allow to determine the type of

Get Access