In biochemistry, the Lineweaver Burk Equation of energy kinetics results in a Lineweaver Burk Plot also known as a Double Reciprocal Plot. Therefore, users may wonder how to make a Lineweaver Burk plot in Excel.
In this article, we demonstrate step-by-step procedures to make a Lineweaver Burk plot in Excel.
Lineweaver Burk Plot and Its Components
What Is Lineweaver Burk Plot?
A Lineweaver Burk Plot is the graphical representation of the Lineweaver Burk Equation. The plot is used to compare with no inhibitor to identify the effectiveness of the inhibitor. The following describes the Lineweaver Burk plot’s components,
Substrate Concentration
Substrate Concentration, S. X-axis of the Lineweaver Burk plot that is reciprocal of substrate concentration, [1/S].
Initial Velocity
Initial Velocity during an enzyme-inhibited reaction, V or Vo. Y-axis of the Lineweaver Burk plot that is reciprocal of velocity, [1/Vo].
Maximum Velocity
Maximum Velocity of the enzyme-inhibited reaction, Vmax. Y-axis interception of the plot is reciprocal of maximum velocity, [1/Vmax].Â
Michaelis Constant
Michaelis Constant, Km is the measurement of enzyme affinity. X-axis interception of the plot is reciprocal of Michaelis Constant, [-1/Km].
How to Make a Lineweaver Burk Plot in Excel: Step-by-Step Procedure
Making a Lineweaver Burk plot requires data on Substrate Concentration (S) and Initial Velocity (Vo). Reciprocals of those result in displaying a Lineweaver Burk plot.
Go through the following steps to make a Lineweaver Burk plot in Excel.
Step 1: Setting Up the Data
Users need to compile the raw substrate concentration and initial velocity data as depicted in the picture below.
- Find the reciprocals of both raw data (i.e., S and Vo) as instructed in the picture.
Read More: How to Plot Semi Log Graph in Excel
Step 2: Inserting a Scatter Plot
After setting up the data, users need to insert a Scatter Plot. As we mentioned earlier, stretching the scatter plot trendline backward results in a lineweaver burk plot.
- Highlight the reciprocals, leaving the first non-value entries, and then go to Insert > Insert Scatter (inside Charts section) > Click Scatter.
- Excel inserts a Scatter Plot as shown in the latter image, instantly.
Read More: How to Plot Time Series Frequency in Excel
Step 3: Modifying Scatter Plot to Make a Lineweaver Burk Plot in Excel
As for now, we’ve inserted a Scatter Plot using the reciprocals. Stretching the scatter plot Trendline Backward results in a Lineweaver Burk plot.
- Click on a point in the plot, then right-click on it. The Context Menu appears.
- Then, select Add Trendline.
- Excel brings up the Format Trendline side window. In the window,
- Firstly, select Linear (Under Trendline Options)
- Then, enter the Backward value 0.07 or any suitable value.
- Finally, tick Display Equation on Chart.
- Choose a preferable plot design. Finally, the Lineweaver Burk plot may look like the screenshot below.
Read More: How to Make a Time Series Graph in Excel
⧠Notes: The Lineweaver Burk Plot may have a different depiction depending on the intensity of its components. Therefore, the following image displays multiple Lineweaver Burk plots distinguishing between inhibition and no inhibition reactions.
Download Excel Workbook
Conclusion
This article discusses the step-by-step procedures of making a Lineweaver Burk Plot in Excel. We hope this article sheds enough light on making a Lineweaver Burk plot to enable you to make one.
Related Articles
<< Go Back To How to Create a Chart in Excel |Â Excel Charts |Â Learn Excel
Get FREE Advanced Excel Exercises with Solutions!
