Question

How to make a Lineweaver-Burk plot in Excel?

A. Use the "Insert Scatter Plot" function
B. Select the data and choose the "Line Chart" option
C. Invert the y-axis and plot the reciprocal of substrate concentration
D. Apply a logarithmic scale to both axes

Answer 1

To create a Lineweaver-Burk plot in Excel, input your data, calculate the reciprocals of velocity and substrate concentration, plot those as a scatter plot, and then use regression to find the line of best fit and equation.

Step-by-step explanation:

To create a Lineweaver-Burk plot in Excel, which is used in enzyme kinetics, follow these steps:

1. Enter your enzyme velocity and substrate concentration data into two separate columns in an Excel worksheet.
2. Calculate the reciprocal of the velocity (1/V) and the reciprocal of the substrate concentration (1/[S]) and put these calculations in two additional columns.
3. Select the data for the reciprocal of the substrate concentration (1/[S]) and the reciprocal of the velocity (1/V) and use the "Insert Scatter Plot" function to create a scatter plot.
4. Once the scatter plot has been made, use Excel's regression function to find the equation of the least-squares regression line. This is done by adding a trendline to the scatter plot and selecting the option to show the equation on the chart.
5. The regression line on your Lineweaver-Burk plot can then be used to calculate important parameters such as Km and Vmax.

Calculation of the Lineweaver-Burk equation's slope and y-intercept allows for the determination of these enzyme kinetics parameters.