Reply Helpful Thread reply – more options Link to this Post. Now go back and add a line to the plot by going under Chart , Add Trendline. Next fill the substrate column with concentrations from 0 – 5 Go to Edit – Fill – Series , when the dialog box comes up click on the radio button for columns under Series in , then set the step value to 0. Can you provide a more detailed description of a Lineweaver Burk plot, and of the data that is plotted compared with the data that has been measured, and is recorded on your data table. It didn’t show how to make a correct graph using numbers. The formulas for converting the data pairs are simple reciprocals, and the chart itself is a scatter plot with a ‘best fit’ linear trend line added.

Analogously to our titration exercise, we will use the M-M equation as our model for the enzyme reaction system. Next plot your results. Posted on Apr 6, 6: Also their example was different from the one I need. It didn’t show how to make a correct graph using numbers. Apr 4, 6: Apr 6, 6:

I am not sure how to go from a basic scatter plot chart to a double reciprocal plot.

Chem M M Kinetics

Apr 4, 9: The Ogden professor’s interpretation of “Lineweaver Burk plot” would appear to be different from what you are asking for.

I am trying to make a double reciprocal plot from my enzyme data. The same kinds of techniques we used before for the titration curves will be used. The formulas for converting the data pairs are simple reciprocals, and the chart itself is a scatter plot with a ‘best fit’ linear trend line added.

Set up your spread sheet as in the figure:. What are its problems? How was this data derived?

This is done using the constant values in the equations for each slope, shown at top left of the chart, in formulas in E2 and E3.

I got my macbook in and the software is: Duplicate and copy your spread sheet columns capture the columns with the mouse, then click on a cell, say F, and hit enter:. Reply Helpful Thread reply – more options Link to this Post.

This is converted to the reciprocal values in rows of columns E, F and G respectively, header labels are added in row 1 a header rowand cells E4-G7 are selected and a scatte chart created.

All replies Drop Down menu. Then change the value of K m to 0.

ln Next fill the substrate column with concentrations from 0 – 5 Go to Edit – Fill – Serieswhen the p,ot box comes up click on the radio button for columns under Series inthen set the step value to 0.

Question marked as Solved User profile for user: The chart shows the initial velocity of the substrates with and without inhibition. Posted on Apr 4, 4: View answer in context.

Ask a question Reset. How do these values compare to each other and to the “real” values.

Apr 4, 8: The data from your table is in rows of columns A, B and C. Can you provide a more detailed description of a Lineweaver Burk plot, and of the data that is plotted compared with the data that has been measured, and is recorded on your data table.

For this exercise we need to set up columns for the various parameters in the Michaelis-Menten equation. plott

So something like this, then? Analogously to our titration exercise, we will use the M-M equation as our model for the enzyme reaction system. Ignoring the lineweavr-burk values for Km and Vmax, find them graphically from your plots. Zeroes are added manually in G2 and F3 to specify the Y value where each slope meets the x axis, then the chart is selected again, and the selection rectangle enclosing cells E4-G7 is slid up two rows, then extended down two rows to include cells E2 – G7.

When trend lines and the trend line equations are added, it resembles the one in your initial post. Apr 6, amke What labels should be on each column? Now go back and add a line to the plot by going under ChartAdd Trendline. To start the conversation again, simply ask a new question. Go to Insert – Chart How accurate and effective do you think this mke is for finding values from real data?

need to make a lineweaver burk plot, also known as a double reciprocal plot

It didn’t show how to make a correct graph using numbers. In the dialog boxes choose linear, then double-click on the line and under options choose display equation and r-squared Posted on Apr 6, 6: I checked the site.

The three unlabelled columns are the reciprocal values of the input data in order. Make a new chart of this data, labeling appropriately etc. Apr 4, 6:

This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT

Privacy & Cookies Policy

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are as essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.

Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.

Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.