JCE Online Journal of Chemical Education
 | Subscriptions  | Software Orders  | Support  | Contributors  | Advertisers  | 

JCE Print

JCE Digital Library

JCE Software

Only@JCE Online

About JCE


  Home > JCE Print > Journal of Chemical Education > Issues > 2000  > November  >
Information • Textbooks • Media • Resources
Computer Bulletin Board
Analysis of First-Order Kinetics Using Microsoft Excel Solver
Philip Denton
School of Pharmacy and Chemistry, Liverpool John Moores University, Liverpool L3 3AF, UK

Cover
November 2000
Vol. 77 No. 11
p. 1524

Abstract
Experimental data from kinetics investigations may be analyzed using Microsoft Excel Solver. The procedure provides an attractive means of introducing the principles of nonlinear data analysis to students and overcomes difficulties associated with both conventional and time-lag approaches. Students can determine the standard error in Solver-determined regression parameters and the square of the correlation coefficient, R2, using a procedure that does not necessitate the repeated application of Solver.
Supplement
Supplemental material describing how MS Excel Solver may be used to analyze data from the iodideŠpersulfate reaction is available.
*  Contents JCE2000p1524W.doc (Microsoft Word 6.0, Windows)
*  Download
JCE2000p1524W.pdf

JCE2000p1524W.sit

JCE2000p1524W.zip

More Information
*  Citation
Denton, Philip. J. Chem. Educ. 2000 77 1524.
*  Keywords
Kinetics; Aqueous Solution Chemistry; UV-Vis Spectroscopy; Physical Chemistry; Statistics / Data Analysis
*  History
Created:
Last Updated:
October 6, 2000
August 31, 2005
  Home > JCE Print > Journal of Chemical Education > Issues > 2000  > November  > Page 1524


Subscriptions

JCE HS CLIC

Our Secondary School editors work hard to distill all the JCE materials to produce a fraction of particular interest to high school teachers. We call it CLIC.


Contributions Welcome
JCE welcomes your submission

Advertisers
In recent years we have worked hard to better match our advertisers with our readers. When shopping for chemistry education materials, visit our advertisers' WWW sites first.

Be An Ambassador
Take JCE along on your outreach missions. Copies of the Journal, guest access to JCE Online, our publications catalog, and more are available for your participants.