Cart
Article
Curve Fitting, Confidence Intervals and Envelopes, Correlations, and Monte Carlo Visualizations for Multilinear Problems in Chemistry: A General Spreadsheet Approach
Hi-Res PDFPurchase the full-text
- PDF/HTML,
figures/images,
references and tables,
(where available)
Abstract
A spreadsheet approach is used to fit multilinear functions with three adjustable parameters: ƒ = a1X1(x) + a2X2(x) + a3X3(x). Results are illustrated for three familiar examples: IR analysis of gaseous DCl, the electronic/vibrational spectrum of gaseous I2, and van Deemter plots of chromatographic data. These cases are simple enough for students in upper-level physical or advanced analytical courses to write and modify their own spreadsheets. In addition to the original x, y, and σy values, 12 columns are required: three for Xn(xi) values, six for Xn(xi)Xk(xi) product sums for the curvature matrix [α], and three for yi Xn(xi) sums for (b) in the vector equation (b) = [α](a). The Excel spreadsheet MINVERSE function provides the [ε] error matrix from [α]. The [ε] elements are then used to determine best-fit parameter values contained in (a). These spreadsheets also use a "dimensionless" or "reduced parameter" approach in calculating parameter weights, uncertainties, and correlations. Students can later enter data sets and fit parameters into a larger spreadsheet that uses Monte Carlo techniques to produce two-dimensional scatter plots. These correspond to Δχ2 ellipsoidal cross-sections or projections and provide visual depictions of parameter uncertainties and correlations. The Monte Carlo results can also be used to estimate confidence envelopes for fitting plots.
Keywords (Audience):
Upper-Division UndergraduateKeywords (Domain):
Physical ChemistryKeywords (Feature):
Computer Bulletin BoardKeywords (Subject):
ChromatographyCiting 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 8 ACS Journal articles (5 most recent appear below).
Error Propagation Made Easy—Or at Least Easier
George H. Gardenier, Feng Gui, and James N. DemasJournal of Chemical Education2011 Article ASAPError Propagation Made Easy—Or at Least Easier
George H. Gardenier, Feng Gui, and James N. DemasJournal of Chemical Education2011 Article ASAPComplex error propagation is reduced to formula and data entry into a Mathcad worksheet or an Excel spreadsheet. The Mathcad routine uses both symbolic calculus analysis and Monte Carlo methods to propagate errors in a formula of up to four variables. ...
Exercise in Quality Assurance: A Laboratory Exercise
Jens E. T. AndersenJournal of Chemical Education2009 86 (6), 733Exercise in Quality Assurance: A Laboratory Exercise
Jens E. T. AndersenJournal of Chemical Education2009 86 (6), 733A laboratory exercise in quality assurance (QA) of analytical chemistry is presented. Quality assurance is considered by students to be difficult, and it is also a demanding subject to the teachers, owing to the multitude of methods available to the ...
Design of an Excel Spreadsheet To Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent
Ruben Elvas-Leitão , Luís Moreira and Filomena MartinsJournal of Chemical Education2006 83 (12), 1879Design of an Excel Spreadsheet To Estimate Rate Constants, Determine Associated Errors, and Choose Curve's Extent
Ruben Elvas-Leitão , Luís Moreira and Filomena MartinsJournal of Chemical Education2006 83 (12), 1879In 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 ...
First-Order or Second-Order Kinetics? A Monte Carlo Answer
Joel TellinghuisenJournal of Chemical Education2005 82 (11), 1709First-Order or Second-Order Kinetics? A Monte Carlo Answer
Joel TellinghuisenJournal of Chemical Education2005 82 (11), 1709In chemical kinetics, data for the concentration [A] as a function of time can be analyzed by least-squares fitting to the appropriate expression for the integrated rate law. The problem of discriminating between first and second order in such analyses is ...
Global Least-Squares Analysis of the IR Rotation–Vibration Spectrum of HCl
Joel TellinghuisenJournal of Chemical Education2005 82 (1), 150Global Least-Squares Analysis of the IR Rotation–Vibration Spectrum of HCl
Joel TellinghuisenJournal of Chemical Education2005 82 (1), 150The study of the IR rotation–vibration spectrum is a mainstay of the undergraduate laboratory curriculum in spectroscopy. Typical spectra consist of the fundamental and overtone bands for H35Cl and H37Cl (and sometimes D35Cl and D37Cl). These can be ...
Full Text HTMLTools
-
Add to Favorites
-
Download Citation
-
Email a Colleague -
Permalink
Order Reprints
Rights & Permissions
Citation Alerts
History
- Received: August 03, 2009
ACS
Network
Facebook
Tweet This
CiteULike
Newsvine
Digg This
Delicious
