BIBLIOS

Document type
Journal articles

Document subtype
Full paper

Title
Design of an Excel Spreadsheet to Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent

Participants in the publication
L. Moreira (Author)
F. Martins (Author)
Dep. Química e Bioquímica
R. E. Leitão (Author)

Summary
In this article we wish to present a new Microsoft Excel spreadsheet design that enables a prompt calculation of rate constant values (k) and associated errors and also addresses less common features such as the choice of experimental curve's extent. The step-by-step description of the design provides the opportunity to deal with other, less used, Excel tools. The performed direct calculation of uncertainties, via established formulas, offers the possibility of acquiring an insightful knowledge of statistical and numerical analysis theory and its practical application on spreadsheet designs. Selected examples, given as Supplemental Material, provide the chance to directly interact with the devised spreadsheet before the user starts to construct his or her own spreadsheet.


Institution
FACULDADE DE CIÊNCIAS DA UNIVERSIDADE DE LISBOA

Where published
Journal of Chemical Education

Publication Identifiers

Publisher
American Chemical Society



Document Identifiers
DOI - https://doi.org/10.1021/ed083p1879t

Rankings
SCIMAGO Q3 (2006) - 0.273 - Chemistry
Web Of Science Q3 (2006) - 0.493 - Education, Scientific disciplines
Web Of Science Q4 (2006) - 0.493 - Chemistry