Excel 2007 - Integrated Rate Law

Here we create 3 different plots to evaluate if the reaction is zero order, first order, or second order.

Category:

Education

Tags:

• Screencast-O-Matic.com
• kinetics
• chemistry
• ratelaw
• excel2007
• excel
• integratedratelaw

[reyrey389]

besides this, is there anyother way besides graphing? cuz on an actual test u cant use this and graphing takes long.

thank you

[profpiersol]

@reyrey389 Yes there is another way: Only one plot will yield a straight line, right? A straight line has a constant slope. For a given experiment (say [A] vs t) Calculate the slope with early data points, then calculate the slope again with later data points. If the slope is the same, it is zero order. If not, repeat this process using (ln[A] vs t). If the slope is the same, it is 1st order, otherwise check (1/[A] vs t). Hope this helps!

[profpiersol]

@freak1east: This is done by using pseudo-first order approximation. One reactant is made to be much larger in concentration than the other, so that it's concentration changes very little as the reaction progresses. You can then monitor [A] vs time for one reactant only. Try googling "pseudo first order" and see what you find or visit with your professor or TA.

[ShEwHyLL]

THANK YOU SO MUCH.♥ IT HELPED ME A LOT. 

[CalixLuv]

Thank you so much!

[kelsafish]

Thanks! This helped me immensely! 

[nodough12]

That was exactly what i needed! thank you soo much for the help!

[freak1east]

Hey could you please help me with plotting a graph for a second order reaction with two reactants of a different concentration

[moondittostar]

Thank you for posting this video! I know know how to use excel to find the reaction order!