Nonlinear Least Squares Curve Fitting with Microsoft Excel Solver

  • Harris D
  • 2

    Readers

    Mendeley users who have this article in their library.
  • N/A

    Citations

    Citations of this article.

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.

Get free article suggestions today

Mendeley saves you time finding and organizing research

Sign up here
Already have an account ?Sign in

Find this document

Authors

  • Daniel C Harris

Cite this document

Choose a citation style from the tabs below

Save time finding and organizing research with Mendeley

Sign up for free