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?
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.
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 :(
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).
By googling "how to calculate km and vmax excel", gives you as a first hit: