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

Adducts of S/Se Donors with Dihalogens as a Source of Information for Categorizing the Halogen Bonding
M. Carla Aragoni, Massimiliano Arca, Francesco A. Devillanova, Francesco Isaia, and Vito Lippolis
Crystal Growth & Design2012 Article ASAP
- Adducts of S/Se Donors with Dihalogens as a Source of Information for Categorizing the Halogen Bonding
  M. Carla Aragoni, Massimiliano Arca, Francesco A. Devillanova, Francesco Isaia, and Vito Lippolis
  Crystal Growth & Design2012 Article ASAP
  The great variety of products ensuing from the reactions between chalcogen donors and dihalogens and their assemblies in the crystal lattice provides a wide experimental basis useful to disembroil the ongoing debate on how to define the halogen bonding. ...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links
Use of a Spreadsheet To Help Students Understand the Origin of the Empirical Equation That Allows Estimation of the Extinction Coefficients of Proteins
Paul A. Sims
Journal of Chemical Education2012 89 (6), 738-742
- Use of a Spreadsheet To Help Students Understand the Origin of the Empirical Equation That Allows Estimation of the Extinction Coefficients of Proteins
  Paul A. Sims
  Journal of Chemical Education2012 89 (6), 738-742
  A brief history of the development of the empirical equation that is used by prominent, Internet-based programs to estimate (or calculate) the extinction coefficients of proteins is presented. In addition, an overview of a series of related assignments ...
  Abstract | Full Text HTML | Hi-Res PDF | PDF w/ Links
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
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

Tools

SciFinder Links

Explore by:

Author of this Article Any Author Research Topic

History

Received: August 03, 2009

Select a CAS section from the 5 main topical divisions below:

Article

Nonlinear Least-Squares Curve Fitting with Microsoft Excel Solver

Abstract

Keywords (Audience):

Keywords (Domain):

Keywords (Feature):

Keywords (Pedagogy):

Keywords (Subject):

Citing Articles

Adducts of S/Se Donors with Dihalogens as a Source of Information for Categorizing the Halogen Bonding

Adducts of S/Se Donors with Dihalogens as a Source of Information for Categorizing the Halogen Bonding

Use of a Spreadsheet To Help Students Understand the Origin of the Empirical Equation That Allows Estimation of the Extinction Coefficients of Proteins

Use of a Spreadsheet To Help Students Understand the Origin of the Empirical Equation That Allows Estimation of the Extinction Coefficients of Proteins

Metrical Oxidation States of 2-Amidophenoxide and Catecholate Ligands: Structural Signatures of Metal–Ligand π Bonding in Potentially Noninnocent Ligands

Metrical Oxidation States of 2-Amidophenoxide and Catecholate Ligands: Structural Signatures of Metal–Ligand π Bonding in Potentially Noninnocent Ligands

Spectroscopic and X-ray Crystallographic Evidence for Electrostatic Effects in 4-Substituted Cyclohexanone-Derived Hydrazones, Imines, and Corresponding Salts

Spectroscopic and X-ray Crystallographic Evidence for Electrostatic Effects in 4-Substituted Cyclohexanone-Derived Hydrazones, Imines, and Corresponding Salts

A Comprehensive Enzyme Kinetic Exercise for Biochemistry

A Comprehensive Enzyme Kinetic Exercise for Biochemistry

Tools

SciFinder Links

History

Recommend & Share

Related Content

Estimating Parameter Precision in Nonlinear Least Squares with Excel's Solver

Toward the Development of Molecular Wires: A Terpyridine Spacer Containing Polyferrocenylalkyne Linkages

Excel Tutorial: Using the Least-Squares Method To Calculate Unknown Concentrations and Error

JOURNALS

BOOKS

C&EN

TOOLS

COMMUNITIES

DIRECTORIES & DATABASES

LEGACY MAGAZINES

Products

User Resources

Support

Partners

Search ACS Publications