Nonlinear least-squares data fitting in Excel spreadsheets
Top Cited Papers
- 28 January 2010
- journal article
- Published by Springer Science and Business Media LLC in Nature Protocols
- Vol. 5 (2), 267-281
- https://doi.org/10.1038/nprot.2009.182
Abstract
We describe an intuitive and rapid procedure for analyzing experimental data by nonlinear least-squares fitting (NLSF) in the most widely used spreadsheet program. Experimental data in x/y form and data calculated from a regression equation are inputted and plotted in a Microsoft Excel worksheet, and the sum of squared residuals is computed and minimized using the Solver add-in to obtain the set of parameter values that best describes the experimental data. The confidence of best-fit values is then visualized and assessed in a generally applicable and easily comprehensible way. Every user familiar with the most basic functions of Excel will be able to implement this protocol, without previous experience in data fitting or programming and without additional costs for specialist software. The application of this tool is exemplified using the well-known Michaelis-Menten equation characterizing simple enzyme kinetics. Only slight modifications are required to adapt the protocol to virtually any other kind of dataset or regression equation. The entire protocol takes approximately 1 h.Keywords
This publication has 62 references indexed in Scilit:
- Modeling transitions in body composition: the approach to steady state for anthropometric measures and physiological functions in the Minnesota human starvation studyDynamic Medicine, 2008
- Using circular dichroism collected as a function of temperature to determine the thermodynamics of protein unfolding and binding interactionsNature Protocols, 2006
- Caged Capsaicins: New Tools for the Examination of TRPV1 Channels in Somatosensory NeuronsChemBioChem, 2006
- Gel permeation chromatography of dextrans in parenteral solutions: Calibration procedure development and method validationJournal of Pharmaceutical and Biomedical Analysis, 2006
- Thermodynamics of Lipid Membrane Solubilization by Sodium Dodecyl SulfateBiophysical Journal, 2006
- Membrane‐Mimetic Nanocarriers Formed by a Dipalmitoylated Cell‐Penetrating PeptideAngewandte Chemie, 2005
- Estimating microbial population counts by ‘most probable number’ using Microsoft Excel®Journal of Microbiological Methods, 1999
- Titration calorimetry of lipid–peptide interactionsBiochimica et Biophysica Acta (BBA) - Reviews on Biomembranes, 1997
- Biological modeling on a microcomputer using standard spreadsheet and equation solver programs: The hypothalamic-pituitary-ovarian axis as an exampleComputers and Biomedical Research, 1992
- The Determination of Enzyme Dissociation ConstantsJournal of the American Chemical Society, 1934