Cart
Article
Estimating Parameter Precision in Nonlinear Least Squares with Excel's Solver
Hi-Res PDFPurchase the full-text
- PDF/HTML,
figures/images,
references and tables,
(where available)
Abstract
A macro is described that computes the precision of the parameters obtained with Microsoft Excel Solver, and several examples illustrate its use.
Keywords (Audience):
Upper-Division UndergraduateKeywords (Domain):
Analytical ChemistryKeywords (Feature):
Computer Bulletin BoardKeywords (Pedagogy):
Computer-Based LearningKeywords (Subject):
Quantitative AnalysisCiting 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 27 ACS Journal articles (5 most recent appear below).
Metrical Oxidation States of 2-Amidophenoxide and Catecholate Ligands: Structural Signatures of Metal–Ligand π Bonding in Potentially Noninnocent Ligands
Seth N. BrownInorganic Chemistry2012 51 (3), 1251-1260Metrical Oxidation States of 2-Amidophenoxide and Catecholate Ligands: Structural Signatures of Metal–Ligand π Bonding in Potentially Noninnocent Ligands
Seth N. BrownInorganic Chemistry2012 51 (3), 1251-1260Catecholates and 2-amidophenoxides are prototypical “noninnocent” ligands which can form metal complexes where the ligands are best described as being in the monoanionic (imino)semiquinone or neutral (imino)quinone oxidation state instead of their closed-...
Collinearity in Least-Squares Analysis
Robert de LevieJournal of Chemical Education2012 89 (1), 68-78Collinearity in Least-Squares Analysis
Robert de LevieJournal of Chemical Education2012 89 (1), 68-78How useful are the standard deviations per se, and how reliable are results derived from several least-squares coefficients and their associated standard deviations? When the output parameters obtained from a least-squares analysis are mutually ...
Nonisothermal Analysis of Solution Kinetics by Spreadsheet Simulation
Robert de LevieJournal of Chemical Education2012 89 (1), 79-86Nonisothermal Analysis of Solution Kinetics by Spreadsheet Simulation
Robert de LevieJournal of Chemical Education2012 89 (1), 79-86A fast and generally applicable alternative solution to the problem of determining the useful shelf life of medicinal solutions is described. It illustrates the power and convenience of the combination of numerical simulation and nonlinear least squares ...
The Kinetics of H2–D2 Exchange over Pd, Cu, and PdCu Surfaces
Casey P. O’Brien, James B. Miller, Bryan D. Morreale, and Andrew J. GellmanThe Journal of Physical Chemistry C2011 115 (49), 24221-24230The Kinetics of H2–D2 Exchange over Pd, Cu, and PdCu Surfaces
Casey P. O’Brien, James B. Miller, Bryan D. Morreale, and Andrew J. GellmanThe Journal of Physical Chemistry C2011 115 (49), 24221-24230PdCu alloy membranes are promising candidates for hydrogen separation from H2S-containing gas mixtures. Dissociative H2 adsorption and associative desorption are important steps in the process of hydrogen transport across PdCu membranes; however, the ...
Infiltration of Outdoor Ultrafine Particles into a Test House
Donghyun Rim, Lance Wallace and Andrew PersilyEnvironmental Science & Technology2010 44 (15), 5908-5913Infiltration of Outdoor Ultrafine Particles into a Test House
Donghyun Rim, Lance Wallace and Andrew PersilyEnvironmental Science & Technology2010 44 (15), 5908-5913Ultrafine particles (UFP) (<100 nm) have been related to adverse human health effects such as oxidative stress and cardiovascular mortality. However, human exposure to particles of outdoor origin is heavily dependent on their infiltration into homes. The ...
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
