Tech Report
An Excel Program to Study First-Order Kinetics
Abstract
Software to analyze and to simulate first-order kinetics data (ExpoDecay) has been developed using Microsoft Excel 97 with Visual Basic for Applications. Data can be analyzed by least-squares with and without weighting. The results can be assessed by Student's t-test and ANOVA tables. Half-life and a 95% confidence interval for an observed value at time t are given also. For simulation, noise can be added by the constant-variance model and by the constant coefficient of variation model.
Keywords (Audience):
Second-Year UndergraduateKeywords (Feature):
JCE WebWareKeywords (Pedagogy):
Computer-Based LearningKeywords (Subject):
Computational ChemistryCiting Articles
Citation data is made available by participants in CrossRef's Cited-by Linking service. For a more comprehensive list of citations to this article, users are encouraged to perform a search in SciFinder.
This article has been cited by 4 ACS Journal articles (4 most recent appear below).

The Finkelstein Reaction: Quantitative Reaction Kinetics of an SN2 Reaction Using Nonaqueous Conductivity
R. David Pace and Yagya RegmiJournal of Chemical Education2006 83 (9), 1344The Finkelstein Reaction: Quantitative Reaction Kinetics of an SN2 Reaction Using Nonaqueous Conductivity
R. David Pace and Yagya RegmiJournal of Chemical Education2006 83 (9), 1344Two essential concepts for students to grasp in the undergraduate organic chemistry sequence are substitution chemistry and elimination chemistry (SN1/SN2 and E1/E2). However, students are often confounded by the seemingly endless series of structure–...

Promoting Graphical Thinking: Using Temperature and a Graphing Calculator To Teach Kinetics Concepts
Deborah A. Moore-Russo , José E. Cortés-Figueroa , Mark CaseJournal of Chemical Education2004 81 (1), 69Promoting Graphical Thinking: Using Temperature and a Graphing Calculator To Teach Kinetics Concepts
Deborah A. Moore-Russo , José E. Cortés-Figueroa , Mark CaseJournal of Chemical Education2004 81 (1), 69A Calculator-Based Laboratory (CBL) System, a graphing calculator, and a cooling piece of metal are used in a classroom demonstration to teach key concepts of a first-order chemical reaction.

Kinetica: An Excel Program To Simulate or Analyze Kinetic Data
Leonel R. Vera , Pedro A. Ortega and Miguel GuzmánJournal of Chemical Education2004 81 (1), 159Kinetica: An Excel Program To Simulate or Analyze Kinetic Data
Leonel R. Vera , Pedro A. Ortega and Miguel GuzmánJournal of Chemical Education2004 81 (1), 159Instructors or students can generate simulated kinetic data using parameters they specify, or using parameters randomized by Kinetica. The data set that is generated may then be exported for use in exercises, homework, and exams, or may be analyzed ...

Peer-Reviewed JCE WebWare
William F. Coleman , Edward W. FedoskyJournal of Chemical Education2004 81 (1), 159Peer-Reviewed JCE WebWare
William F. Coleman , Edward W. FedoskyJournal of Chemical Education2004 81 (1), 159To celebrate the official initiation of the Journal of Chemical Education Digital Library, this month we add “Kinetica: An Excel Program To Simulate or Analyze Kinetic Data” to our collection of 20 peer-reviewed WebWare programs.
Tools
-
Add to Favorites
-
Download Citation
-
Email a Colleague -
Permalink
Order Reprints
Rights & Permissions
Citation Alerts
History
- Received: August 03, 2009
Cart
ACS
Network






