Scientist Solutions: International Life Science Community By Scientists For Scientists
    
Home » Forums » Biochemistry » Enzymology » finding Km & Vmax values

Thanks to our sponsors who make this site possible

finding Km & Vmax values

RSS Feed

Would you like to save this topic, event, protocol or job so you can find it again easily?

Just click the "Save to My Lab Drawer" link and the item will be saved in the My Lab Drawer section of your bench space.

Available to members only. Please log in or register for your free account now.

Mon11
New Zealand

Send PM
See Mini bio

Status: Frog Egg
Frog Egg
Topic Started by Mon11
on 10/5/2009 14:48 PM   
Reply to this post Go to the top of the page

Hello everyone,

 I've got  data on Excel, one column is for time (min) the other column is for substrate concentration (mmol/L), how can I calculate the velocity using these two given data by Excel so I can calculate Vmax & Km?


ThanQ..



Attached file: Picture 2.png
Picture 2.png

Replies
DrMobs
Australia

Send PM
See Mini bio

Status: Frog Egg
Frog Egg
Posted By DrMobs
on 10/5/2009 15:59 PM   
Reply to this post Go to the top of the page

Look up Michaelis-Menten kinetics in Wikipedia. You need the enzyme activity (V, in eg abs/unit time; fluorescence/unit time), not time itself. Then you construct a Lineweaver-Burk plot (1/V vs 1/[S]). The y intercept is 1/Vmax and the x intercept is -1/Km.



Mon11
New Zealand

Send PM
See Mini bio

Status: Frog Egg
Frog Egg
Posted By Mon11
on 10/5/2009 22:02 PM   
Reply to this post Go to the top of the page

 Thank you DrMobs,

apparently you didnt get what i want exactly, I need to do that by Excel, without using graphical methods, and I dont have the right formula to calculate the velocity from the time & concentration given, so ill be able to calculate Vmax & Km 

I hope someone can help me with that :(



DrMobs
Australia

Send PM
See Mini bio

Status: Frog Egg
Frog Egg
Posted By DrMobs
on 10/5/2009 22:45 PM   
Reply to this post Go to the top of the page

The time (min) column is not velocity. Do you have more information?
When you have velocity:
Make columns of the reciprocals.
Use the INTERCEPT (c) and SLOPE (m) functions of Excel to get the line parameters (mx+c)
The reciprocal of the INTERCEPT will be Vmax.
Work out what x is when y=0.
Take the negative reciprocal of this to get Km.
(I hope this isn't an assignment or exam question).



Suola
United States

Send PM
See Mini bio

Status: Protein Chemistry and Bioinformatics Moderator
Frog Laureate
Posted By Suola
on 10/6/2009 4:17 AM   
Reply to this post Go to the top of the page

Mon11,

By googling "how to calculate km and vmax excel", gives you as a first hit:

http://www.biotech.sfasu.edu/bt/BTC560/HOW%20TO.htm

Cheers,

Certainty of death, small chance of success... What are we waiting for? - Gimli



As a Scientist Solutions member, you are able to register a positive vote for any topic which you believe is useful and relevant to our board or any reply which you believe is especially well worded and helpful.

By participating in the voting, you will be helping to identify the best topics & replies on the board.

You may vote once for any one post, and you may not vote for your own posts.

A post (topic or reply) will earn one "thumbs up" icon for every 10 votes received (up to 3 thumbs up), and the person who made the post will also earn two bonus points.

learn more about member points.