BIBLIOS

Tipo
Artigos em Revista

Tipo de Documento
Artigo Completo

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

Participantes na publicação
L. Moreira (Author)
F. Martins (Author)
Dep. Química e Bioquímica
R. E. Leitão (Author)

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


Instituição
FACULDADE DE CIÊNCIAS DA UNIVERSIDADE DE LISBOA

Suporte
Journal of Chemical Education

Identificadores da Publicação

Editora
American Chemical Society



Identificadores do Documento
DOI - https://doi.org/10.1021/ed083p1879t

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