Analyze enzyme lab data using Microsoft Excel !! only for reference, the data sets presented here are just an example. Microsoft Excel. ▲Open the bottom left corner, there are sheet the sheets as ▲On “sheet 1, sheet 2, and 3”, you can rename “substrate, inhibitor, pH”. data into each of the corresponding sheet. In the first column (column A), enter time as ▲Enter your minutes (0.5, 1.0, 1.5, etc..) in other columns, enter your OD460nm data. Example: the menu, choose scatter with only markers. ▲On choose insert→ charts→ scatter, the upper left and select your data range in ▲The graph should appear, if not, then click “select data” on the data sheet. click on the chart, the chart tools bar should appear on the top, choose the chart ▲Double “layout 3” from layouts.
Analyze enzyme lab data using Microsoft Excel !! only for reference, the data sets presented here are just an example. ▲Open Microsoft Excel. ▲On the bottom left corner, there are “sheet 1, sheet 2, and sheet 3”, you can rename the sheets as “substrate, inhibitor, pH”. ▲Enter your data into each of the corresponding sheet. In the first column (column A), enter time as minutes (0.5, 1.0, 1.5, etc..) in other columns, enter your OD460nm data. Example: ▲On the menu, choose insert→ charts→ scatter, choose scatter with only markers. ▲The graph should appear, if not, then click “select data” on the upper left and select your data range in the data sheet. ▲Double click on the chart, the chart tools bar should appear on the top, choose “layout 3” from the chart layouts.
Enzymelabanalysis.docx