Skip to content

Nonlinear Least Squares Curve Fitting with Microsoft Excel Solver

by Daniel C Harris
Journal of Chemical Education ()
Get full text at journal


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

Cite this document (BETA)

Readership Statistics

2 Readers on Mendeley
by Discipline
50% Chemistry
50% Engineering
by Academic Status
50% Researcher
50% Student > Doctoral Student
by Country
50% Kenya
50% United States

Sign up today - FREE

Mendeley saves you time finding and organizing research. Learn more

  • All your research in one place
  • Add and import papers easily
  • Access it anywhere, anytime

Start using Mendeley in seconds!

Sign up & Download

Already have an account? Sign in