Nonlinear Least Squares Curve Fitting with Microsoft Excel Solver
- DOI: 10.1021/ed075p119
"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.