An Excel Program to Study First-Order Kinetics

Ken Muranaka
K''s Garden Nishioji, Kasuga Hachijo Sagaru, Minami-ku, Kyoto, Japan
J. Chem. Educ., 2002, 79 (1), p 135
DOI: 10.1021/ed079p135.3
Publication Date (Web): January 1, 2002

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 Undergraduate

Keywords (Feature):

JCE WebWare

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Computational Chemistry

Citing 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).

  • Cover Image

    The Finkelstein Reaction: Quantitative Reaction Kinetics of an SN2 Reaction Using Nonaqueous Conductivity

    R. David Pace and Yagya Regmi
    Journal of Chemical Education2006 83 (9), 1344
    • The Finkelstein Reaction: Quantitative Reaction Kinetics of an SN2 Reaction Using Nonaqueous Conductivity

      R. David Pace and Yagya Regmi
      Journal of Chemical Education2006 83 (9), 1344

      Two 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–...

  • Cover Image

    Promoting Graphical Thinking: Using Temperature and a Graphing Calculator To Teach Kinetics Concepts

    Deborah A. Moore-Russo , José E. Cortés-Figueroa , Mark Case
    Journal of Chemical Education2004 81 (1), 69
    • Promoting Graphical Thinking: Using Temperature and a Graphing Calculator To Teach Kinetics Concepts

      Deborah A. Moore-Russo , José E. Cortés-Figueroa , Mark Case
      Journal of Chemical Education2004 81 (1), 69

      A 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.

  • Cover Image

    Kinetica: An Excel Program To Simulate or Analyze Kinetic Data

    Leonel R. Vera , Pedro A. Ortega and Miguel Guzmán
    Journal of Chemical Education2004 81 (1), 159
    • Kinetica: An Excel Program To Simulate or Analyze Kinetic Data

      Leonel R. Vera , Pedro A. Ortega and Miguel Guzmán
      Journal of Chemical Education2004 81 (1), 159

      Instructors 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 ...

  • Cover Image

    Peer-Reviewed JCE WebWare

    William F. Coleman , Edward W. Fedosky
    Journal of Chemical Education2004 81 (1), 159
    • Peer-Reviewed JCE WebWare

      William F. Coleman , Edward W. Fedosky
      Journal of Chemical Education2004 81 (1), 159

      To 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

SciFinder Links

SciFinder subscribers:  Click to sign in | Not a SciFinder subscriber? Learn more at www.cas.org

Explore by:


History

  • Received: August 03, 2009

Recommend & Share

  • Share on ACS NetworkACS Network
  • Add to FacebookFacebook
  • Tweet ThisTweet This
  • Add to CiteULikeCiteULike
  • Add to NewsvineNewsvine
  • Digg ThisDigg This
  • Add to DeliciousDelicious

Related Content