Nonlinear least-squares data fitting in Excel spreadsheets.

Nature Protocols
Gerdi Kemmer, Sandro Keller

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.

References

Nov 1, 1992·Analytical Biochemistry·M L Johnson
Jan 13, 1995·Journal of Immunological Methods·P W Stevens, D M Kelso
Mar 14, 1997·Biochimica Et Biophysica Acta·J Seelig
Apr 7, 1999·Journal of Microbiological Methods·A M Briones, W Reichardt
Jul 28, 1999·Protein Science : a Publication of the Protein Society·C N PaceG I Makhatadze
Nov 9, 2000·Alimentary Pharmacology & Therapeutics·A Sonnenberg
Oct 12, 2001·American Journal of Physical Anthropology·R WardG S Anderson
Dec 4, 2003·Journal of the American College of Surgeons·Paul C KuoR Randall Bollinger
Feb 28, 2004·Applied Radiation and Isotopes : Including Data, Instrumentation and Methods for Use in Agriculture, Industry and Medicine·H Schrader, A Svec
Nov 3, 2004·Biochimica Et Biophysica Acta·Joachim Seelig
Mar 16, 2005·Computers in Biology and Medicine·Chantaratsamon DansirikulStephen B Duffull
Jul 22, 2005·Angewandte Chemie·Sandro KellerMichael Bienert
Jul 26, 2005·Biophysical Journal·Elsa Bárány-WalljeMargitta Dathe
Aug 11, 2005·Journal of the American Chemical Society·Sandro KellerHeiko Heerklotz
Jan 24, 2006·Journal of Dairy Science·J A Burke
Jan 26, 2006·Journal of the American Chemical Society·Sandro KellerAlfred Blume
Mar 1, 2006·Angewandte Chemie·Sidney B CambridgeBeate Cürten
Apr 4, 2006·Biophysical Journal·Sandro KellerAlfred Blume
May 3, 2006·Journal of Pharmaceutical and Biomedical Analysis·S KarmarkarM Koberda
Jul 21, 2006·The Journal of Physical Chemistry. B·Tiago J F BrancoLuis F Vieira Ferreira
Nov 28, 2006·Analytical Biochemistry·Jonathan D Parsons
Dec 13, 2006·Chembiochem : a European Journal of Chemical Biology·Daniel GilbertVolker Hagen
Mar 3, 2007·Chembiochem : a European Journal of Chemical Biology·Sandro KellerAlfred Blume
Nov 6, 2007·Computer Methods and Programs in Biomedicine·Ingolf Meineke, Jürgen Brockmöller
Jul 24, 2008·Langmuir : the ACS Journal of Surfaces and Colloids·Andreas BeckHeiko Heerklotz
Apr 1, 1995·Talanta·S Walsh, D Diamond
Jan 15, 2007·Talanta·A SafaviS Maesum
Jan 27, 2009·Analytical Biochemistry·Kenneth A JohnsonThomas Blom

❮ Previous
Next ❯

Citations

Feb 3, 2011·Analytical and Bioanalytical Chemistry·Meera Shanmuganathan, Philip Britz-McKibbin
Nov 20, 2012·The Journal of Biological Chemistry·Joaquim V MarquesNorman G Lewis
Jan 2, 2013·The Journal of General Physiology·Nima Milani-NejadPaul M L Janssen
Sep 17, 2013·PloS One·Niels GrasmeijerHenderik W Frijlink
Oct 30, 2013·Proceedings of the National Academy of Sciences of the United States of America·Minseon ChoH Tom Soh
Dec 14, 2011·Langmuir : the ACS Journal of Surfaces and Colloids·Kamlesh ShroffEfrosini Kokkoli
Jan 21, 2016·Biochemistry·Kelly E Du PontChristopher E Berndsen
Feb 18, 2016·Biological Procedures Online·Katharina GimplSandro Keller
Dec 10, 2015·Langmuir : the ACS Journal of Surfaces and Colloids·Géraldine KleinJean Philippe Renault
Dec 17, 2014·Proceedings of the National Academy of Sciences of the United States of America·Jonas M DörrJ Antoinette Killian
Sep 15, 2015·The FEBS Journal·Vasiliki E FadouloglouBen F Luisi
Nov 14, 2012·Toxicology and Applied Pharmacology·Isabel A O'ConnorA Jan Hendriks
Aug 5, 2015·Langmuir : the ACS Journal of Surfaces and Colloids·Filipe M Coreta-GomesMaria João Moreno
Nov 12, 2015·Chemico-biological Interactions·Adam T ZarthStephen S Hecht
Oct 11, 2015·Biometals : an International Journal on the Role of Metal Ions in Biology, Biochemistry, and Medicine·Tiziano MarzoLara Massai
Aug 25, 2015·The Science of the Total Environment·M A PrietoIsabel C F R Ferreira
Jan 4, 2012·Journal of Molecular Recognition : JMR·Rajesh GhaiBrett M Collins
Nov 21, 2012·Biochemistry and Molecular Biology Education : a Bimonthly Publication of the International Union of Biochemistry and Molecular Biology·Michael A HefflerJennifer F Kugel
May 4, 2011·Biotechnology and Bioengineering·Sean A GrayMichael J Feldhaus
Aug 15, 2014·Biotechnology and Bioengineering·Ja Kyong KoMichael R Ladisch
Mar 27, 2016·The Science of the Total Environment·Xiaoming Wang, Morton A Barlaz
Mar 31, 2016·Biophysical Journal·Cintia JozefkowiczKarina Alleva

❮ Previous
Next ❯

Related Concepts

Trending Feeds

COVID-19

Coronaviruses encompass a large family of viruses that cause the common cold as well as more serious diseases, such as the ongoing outbreak of coronavirus disease 2019 (COVID-19; formally known as 2019-nCoV). Coronaviruses can spread from animals to humans; symptoms include fever, cough, shortness of breath, and breathing difficulties; in more severe cases, infection can lead to death. This feed covers recent research on COVID-19.

Blastomycosis

Blastomycosis fungal infections spread through inhaling Blastomyces dermatitidis spores. Discover the latest research on blastomycosis fungal infections here.

Nuclear Pore Complex in ALS/FTD

Alterations in nucleocytoplasmic transport, controlled by the nuclear pore complex, may be involved in the pathomechanism underlying multiple neurodegenerative diseases including Amyotrophic Lateral Sclerosis and Frontotemporal Dementia. Here is the latest research on the nuclear pore complex in ALS and FTD.

Applications of Molecular Barcoding

The concept of molecular barcoding is that each original DNA or RNA molecule is attached to a unique sequence barcode. Sequence reads having different barcodes represent different original molecules, while sequence reads having the same barcode are results of PCR duplication from one original molecule. Discover the latest research on molecular barcoding here.

Chronic Fatigue Syndrome

Chronic fatigue syndrome is a disease characterized by unexplained disabling fatigue; the pathology of which is incompletely understood. Discover the latest research on chronic fatigue syndrome here.

Evolution of Pluripotency

Pluripotency refers to the ability of a cell to develop into three primary germ cell layers of the embryo. This feed focuses on the mechanisms that underlie the evolution of pluripotency. Here is the latest research.

Position Effect Variegation

Position Effect Variagation occurs when a gene is inactivated due to its positioning near heterochromatic regions within a chromosome. Discover the latest research on Position Effect Variagation here.

STING Receptor Agonists

Stimulator of IFN genes (STING) are a group of transmembrane proteins that are involved in the induction of type I interferon that is important in the innate immune response. The stimulation of STING has been an active area of research in the treatment of cancer and infectious diseases. Here is the latest research on STING receptor agonists.

Microbicide

Microbicides are products that can be applied to vaginal or rectal mucosal surfaces with the goal of preventing, or at least significantly reducing, the transmission of sexually transmitted infections. Here is the latest research on microbicides.