Prev. Article Next Article Table of Contents

Article

Nonlinear Least-Squares Curve Fitting with Microsoft Excel Solver

Citing Articles

Your current credentials do not allow retrieval of the full text.

Purchase the full-text

PDF/HTML,
figures/images,
references and tables,
(where available)

Daniel C. Harris

Code 4B2200D, Naval Air Warfare Center, 1 Administration Circle, China Lake, CA 93555-6100

J. Chem. Educ., 1998, 75 (1), p 119

DOI: 10.1021/ed075p119

Publication Date (Web): January 1, 1998

Section:

History, Education, and Documentation

Abstract

"Solver" is a powerful tool in the Microsoft Excel spreadsheet that provides a simple means of fitting experimental data to nonlinear functions. The procedure is so easy to use and its mode of operation is so obvious that it is excellent for students to learn the underlying principle of lease squares curve fitting. This article introduces the method of fitting nonlinear functions with Solver and extends the treatment to weighted least squares and to the estimation of uncertainties in the least-squares parameters.

Keywords (Audience):

Upper-Division Undergraduate

Keywords (Domain):

Physical Chemistry

Keywords (Feature):

Computer Bulletin Board

Keywords (Pedagogy):

Computer-Based Learning

Keywords (Subject):

Instrumental Methods

View: Hi-Res PDF | PDF w/ Links

Citing Articles

View all 52 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 52 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. Brown
Inorganic Chemistry2012 51 (3), 1251-1260
- Metrical Oxidation States of 2-Amidophenoxide and Catecholate Ligands: Structural Signatures of Metal–Ligand π Bonding in Potentially Noninnocent Ligands
  Seth N. Brown
  Inorganic Chemistry2012 51 (3), 1251-1260
  Catecholates 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-...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links
Solvent- and Temperature-Dependent Conformational Changes between Hückel Antiaromatic and Möbius Aromatic Species in meso-Trifluoromethyl Substituted [28]Hexaphyrins
Min-Chul Yoon, Pyosang Kim, Hyejin Yoo, Soji Shimizu, Taro Koide, Sumito Tokuji, Shohei Saito, Atsuhiro Osuka, and Dongho Kim
The Journal of Physical Chemistry B2011 115 (50), 14928-14937
- Solvent- and Temperature-Dependent Conformational Changes between Hückel Antiaromatic and Möbius Aromatic Species in meso-Trifluoromethyl Substituted [28]Hexaphyrins
  Min-Chul Yoon, Pyosang Kim, Hyejin Yoo, Soji Shimizu, Taro Koide, Sumito Tokuji, Shohei Saito, Atsuhiro Osuka, and Dongho Kim
  The Journal of Physical Chemistry B2011 115 (50), 14928-14937
  We investigated the photophysical properties of figure-eight-like meso-hexakis(trifluoromethyl) [26]- and [28]hexaphyrins(1.1.1.1.1.1) denoted as TFM26H and TFM28H, respectively, using steady-state and time-resolved spectroscopy along with theoretical ...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links
Substrate Specificity of Sphingobium chlorophenolicum 2,6-Dichlorohydroquinone 1,2-Dioxygenase
Timothy E. Machonkin and Amy E. Doerner
Biochemistry2011 50 (41), 8899-8913
- Substrate Specificity of Sphingobium chlorophenolicum 2,6-Dichlorohydroquinone 1,2-Dioxygenase
  Timothy E. Machonkin and Amy E. Doerner
  Biochemistry2011 50 (41), 8899-8913
  PcpA is an aromatic ring-cleaving dioxygenase that is homologous to the well-characterized Fe(II)-dependent catechol extradiol dioxygenases. This enzyme catalyzes the oxidative cleavage of 2,6-dichlorohydroquinone in the catabolism of pentachlorophenol by ...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links
Spectroscopic and X-ray Crystallographic Evidence for Electrostatic Effects in 4-Substituted Cyclohexanone-Derived Hydrazones, Imines, and Corresponding Salts
David J. Dibble, Joseph W. Ziller, and K. A. Woerpel
The Journal of Organic Chemistry2011 76 (19), 7706-7719
- Spectroscopic and X-ray Crystallographic Evidence for Electrostatic Effects in 4-Substituted Cyclohexanone-Derived Hydrazones, Imines, and Corresponding Salts
  David J. Dibble, Joseph W. Ziller, and K. A. Woerpel
  The Journal of Organic Chemistry2011 76 (19), 7706-7719
  The axial conformer of several 4-substituted cyclohexanone hydrazone salts was found to predominate in solution. Changes in the charge of the molecule and the polarity of the solvent led to changes in the conformational preference of each molecule that ...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links
A Comprehensive Enzyme Kinetic Exercise for Biochemistry
Janice S. Barton
Journal of Chemical Education2011 88 (9), 1336-1339
- A Comprehensive Enzyme Kinetic Exercise for Biochemistry
  Janice S. Barton
  Journal of Chemical Education2011 88 (9), 1336-1339
  This article describes a comprehensive treatment of experimental enzyme kinetics strongly coupled to electronic data acquisition and use of spreadsheets to organize data and perform linear and nonlinear least-squares analyses, all in a manner that ...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links