Experiment I Data Synthesis Essay

548 Words2 Pages

The spreadsheet from the eLearn titled “Experiment I data” was downloaded to the computer. There were three inhibitors data given. The slope (V0) was calculated for each inhibitor data using the time versus response. The formula used to calculate slope was typed = slope (B6:B11, $A$6: $A$11) in the cell right below the last Reponses, and then from that cell dragged horizontally to get the rest of the slope. This step was repeated for Inhibitor 2, and 3 data.
After all the slopes (V0) was calculated for all the inhibitors, the slopes was copied (Ctrl+C) separated depend on the label said I =0, I=5, I=15, I=20 and pasted the cells that labeled V0 under the substrate 1, 5, 10, 20, 40, 80, 160, 320. This step was repeated for Inhibitor 2, and 3.
A graph was constructed for each inhibitor by selected the substrate concentration and V0 of I=0, then the Smooth Line scatter was used to plot the data for this graph. The data of I=5, 15, 20 was copied ( ctrl+C) and pasted on the graph also. The Title of the charge, x-axis, y-axis, and legend were added properly. This step was repeated for inhibitor 2 and 3. …show more content…

The reciprocal formular was typed “=1/” and the [S] cell was selected. The reciprocal of V0 was also done the same way. This procedure was repeated for I=5,15,20 and inhibitor 2 and 3 to yield all the reciprocal data. The plot for Lineweaver-Burk was constructed by using the Marked Scatter graph. The trend line, title and the equation were added to the graph used the chart layout. The graph also was set backward 0.1 period to see where the line hits the X and Y-axis and is use to identify what inhibitor the graph

Open Document