Sign up & Download
Sign in

Nonlinear Least Squares Curve Fitting with Microsoft Excel Solver

by Daniel C Harris
Journal of Chemical Education ()

Abstract

"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
 
 
by Academic Status
 
50% Doctoral Student
 
50% Post Doc
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!

Already have an account? Sign in